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