Try

SELECT * From MyTable WHERE LEN(RTRIM(MyField))>0

>So far, when having the need to get all records where a specific field is not empty, I was using something like this:
>
>

>SELECT * From MyTable WHERE LEN(ALLTRIM(MyField))>0
>

>
>But, 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?