image row size

[neilix]

Can anyone tell me a way to find out the size of an image field in MSSQL2000?
In a database I have a handful of rows out of thousands which are incorrect. the only way I have to find these rows is to get the size of the image field, the ones with a ridiculous size are the ones in error

Thanks

 

[swampBoogie]

datalength

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_4ep4.asp

 

[neilix]

Cheers swampBoogie