Try

DATALENGTH(mshipmsg) > 0

>
>I am working with the table that include a shipping message column defined as:
>
>Data Type:text
>Allow Nulls: no
>Default value: ''
>
>I am trying to write a query that will exclude records where the shipping message column is empty. I tried the following but no luck:
>
>where mshipmsg NOT LIKE '% %'
>where LEN(mshipmsg) > 0
>
>Please help,
>Daniel