asp replace string on recordset

[omar999]

im trying to replace NULL with N/A but I think I have a syntax error .. how do you replace string on recordset via classic asp

so on objRS17and18("P rice_Band_1") should it be something like

Replace("objRS1 7and18("Price_B and_1")", "NULL", "N/A") ??

[jhardman]

you have too many quotes. Try this:

Replace(objRS17and18("Price_Band_1"), "NULL", "N/A")

this will work if it contains the text "NULL", not if it is a null field. If that is the case, the best solution is use isnull in the query. Let me know if this helps.

Jared

[omar999]

hi Jared

thanks for your reply. on the sql table the cell in question contains NULL with an italic font... is this a null field or is NULL actually text?

[jhardman]

hi Jared

thanks for your reply. on the sql table the cell in question contains NULL with an italic font... is this a null field or is NULL actually text?

sounds like a null field. look up the sql command isnull, that allows you to replace null fields with the text you prefer at the query level. I think that's the best solution for you.

Jared