I'd say you would be better changing the SQL to return the appropriate value:
SELECT t1.c1 as t1c1, t1.c2 as t1c2, COALESCE(t2.c1, '') as t2c1, COALESCE(t2.c2, 0) as t2c2
FROM ...
t2.c1 is a string t2.c2 is an integer For more information look up the index on the SQL Server 2000 books online for COALESCE --Colin Mackay--
"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown) Enumerators in .NET: See how to customise foreach loops with C#