SELECT * From MyTable WHERE LEN(ALLTRIM(MyField))>0But, I need to adjust that SQL so it would fit for either VFP or SQL Server. So, I thought about something like this:
SELECT * From MyTable WHERE MyField>""or
SELECT * From MyTable WHERE MyField>" "But, to my surprise, only the 2nd one works. The first one doesn't return any record. Isn't the first suppose to be the same as the second one?