Replacing Null values in SQL

[SteveCarrier]

Hello.

When you have a recordset which contains null values is there a way for you to instruct the SQL to replace the null values with some other value, such as ""(an empty string?).

I may have, for example:
Select ProductID, ProductDesc, ProductSDesc, ProductMDesc from Product where ProductID = strProduct.

For some records ProductSDesc and/or ProductMDesc are null. This causes errors in my code unless I use an isnull() test. I wanted to avoid this by altering the SQL statement if possible.

Thanks alot.

Steve Carrier

 

[SteveCarrier]

Problem solved. Using the Nz() function worked like a charm.

Steve