HI All,

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