>Hi All,
>
>I ave a Problem with the '==' Operator in the SELECT SQL.
>
>My problem is, I have somewher a filter that is set like
>
>SET FILTER TO Field==myVal
>
>
>EXACT is OFF, ANSI is OFF
>
>Now I need to create a SQL SELECT that holds the same records as the filtered table.
>
>if I use something like
>
>lcWhere = IIF(EMPTY(FILTER(),'','WHERE '+FILTER())
>SELECT *;
> FROM MyTable;
> &lcWhere
>
>
>This gives possibly different results because the "==" Operator is differnt for SELECT SQL and any other place.
>
>So I'm thinking about, but could not find a good solution. Replace '==' with "=" and SET ANSI ON will mix up all original "=" statements.
>Using LIKE(MyVal,Filed) works fine - until somebody adds a wildcard to the myVal ...
>
>I run out on ideas on this.
>
>Please help me
>
>Agnes
Agnes,
Yes == in SQL is different and shortcut for Set Ansi On. However why should that be a problem :
set filter to myField == myVal
If myVal is not the same size as the field itself filtering would be selecting no records, something like 'set filter to .f.'
IOW it's the filter causing problem there not the SQL.
Cetin