Issues Select Where function

Good morning,

In order to avoid duplicating SO# in a table, i am trying to search the Sales Order table for any record with the same SO# upon creation of the record. I am using the below:

let NewSO := 'SO#';
cnt((select ‘Sales Order’ where 'SO#’ = NewSO).'SO#')

‘Sales Order’ being the table I am using to store all related information about each sale order and SO# (text field) being the unique sale order number. But I receive a message that ‘Sales Order’ table does not exist.... I think I am doing something wrong with the ‘’ placed around the table name and I have tried without the ‘’ and other combinations but nothing works

what am I doing wrong?

i am having the same issue with a Select Where function which I could not make to work due to table name issues

thank you in advance

rodolphe