>Hi,
>
>I ran into the following, fairly small, issue. I use Stonefield Query (older version) which returns the following expression (when you select one of several):
>
>
>SELECT * FROM MyTable WHERE (inlist(upper(MyTable.MyField),'TEST1','TEST2',))
>
>
>Note that trailing comma, after ('TEST2'). When I execute this expression against VFP database I get error. When I execute this SQL Select against SQL Server, no error.
>
>Does it mean that SQL Server ignores the trailing comma? Or there is another reason for difference for this behavior between VFP and SQL?
Can you check the exact SQL statement being send to SQL Server (using SQL Profiler)? That SQL statement is not valid for SQL Server as there is no native INLIST function.
If it's not broken, fix it until it is.
My Blog