hello u all

i am working on C#.NET with SQL Server 2000 at the back..i have a database and so there are fields in the table that allow null,, so when i leave them emplty the appears <NULL> ,, and when i connect ma table to C# DataGrid there i can see this null i don't want to see this NUll in the Data Grid tell me the solution



Fadi

Write the SQL query such that it returns the first non-null value for the columns that could be null. You can provide the "blank" value...

SELECT COALESCE(field1, '') AS field1, COALESCE(field2, '') AS field2

This will return the field value if it's not null, or '' if it is.