>>><snip>
>>>>>
>>>>>

>>>>>And Not Empty(tablename.columnname)
>>>>>

>>>>>
>>>>
>>>>Look at the DATALENTH() function in SQL-DOL. Also if the field accepts null values you'd use IS NULL.
>>>
>>>George,
>>>
>>>Why would you use DATALENTH() function in this case when 'NOT LEN(tablename.columnname)=0' does the job?
>>
>>Sergey,
>>
>>LEN() only applies to strings. DATALENGTH() can be used on any type, including binary and image.
>
>I still don't get how DATALENGTH() can be used to check for EMPTY().

Sergey,

In T-SQL, let's assume that you have an image field that's used to contain a PDF file. Assume further that you need to check whether or not the last row in the sequence contains a file or not, before you insert a new row.

If there's no data in the in the field, DATALENGTH() will return either 0 (if an empty character string is the default value) or null (if the field allows nulls). So if you issue a query to return the number of rows where DATALENGTH isn't 0 or null, you can find out whether or not to insert a new row.

This, BTW, is based on a recent assignment I had, and works perfectly.