I'm already using the code that you suggested, if you look at my trap code I am using:-
if row(col).GetType().ToString = "System.DBNull"
as suggested
But this still doesn't seem to be the right solution, what about trapping for 'byte[]' where a system SQL datestamp is returned.
Can I not test the object value with a system object directly to see if they compare?
John T Barton
A single picture (or bit of code) is worth a thousand words