>>
>>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.
>
>George,
>
>Thank's for interesting idea. I'll put it in "may be usfull some day" folder. :)

Sergey,

Thanks. Anytime one of my suggestions can be placed in your "May be useful some day" folder, I consider it an honor.