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