>Hi,
>
>The following SQL Select:
>
>
>select 1 from MyTable where MyField = [TEST1] and PK_FLD <> 0
>
>
>works in VFP. But when sending this SQL select to SQL Server I get error:
>
>Invalid column 'TEST1'
>
>Should I replace the brackets?
Yes. Strings should be enclosed in single quotes. In SQL Server only [] will mean field name, as well as double quotes.
If it's not broken, fix it until it is.
My Blog