Replace Null-values

[Charlie]

Hi,

I'm a newby to VB.net.

I'm using an OldDbDataAdapter to retrieve data from a table. In the
SQL I want to replace a NULL-value with a blank. How must I do that?

 

[William Ryan]

You can use ISNULL(myField, replacecementvalue) in your Select statment, of
you can check IsDBNull(yourDataValue), if you wrap it in an
IIF(IsDBNull(yourValue), string.Empty, yourValue)....
http://www.knowdotnet.com/testsite/nullvalues.html

HTH,

Bill