>
>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. :)
--sb--