>Is it possible to use the $ operator in an SQL statement? I would like to create an SQL to select records where a certain character string is contained anywhere within one of the character fields of my table.
>
>If it's not possible to use the $ operator in SQL, is there another way to do it?
>
>Thanks.
It depends on your back-end. In VFP you can use $, in SQL Server you can use LIKE operator (and you can use it for VFP too). I guess you would better be using LIKE operator if you want your code to be SQL Server compatible.
If it's not broken, fix it until it is.
My Blog