>>Try
>>SELECT * From MyTable WHERE LEN(RTRIM(MyField))>0
>>
>
>Is this supported as is in SQL Server?
>
>Also, if it is, then the minor difference with mine would only be to use RTRIM instead of ALLTRIM. Could you elaborate on that topic as to know why you suggest RTRIM? Is it because it is supported in SQL Server as well?
SQL Server doesn't have ALLTRIM function but has RTRIM/LTRIM.
See
http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping
If it's not broken, fix it until it is.
My Blog