Converting Nulls

[hosl9595]

Hi,

I am trying to return a concatenated string from a Progress ODBC query via an OpenLink driver. My problem is that when using the + to concatenate, if any of the columns being concatenated are unknown or null, the whole string returns as null. I am needing to know if there exists a NVL or decode function similar to the ones available in later editions of SQL to convert those to a blank space or anything that would result in the string coming back correctly. I have tried the Replace function, without success. Thanks in advance for any and all help!

Sincerely,

Jarrod E. Hosley
Software Engineer
Tektronix, Inc.

 

[Crittar]

I am not familiar with odbc query - but is it possible to check the individual items before you concatenate and replace unknown / nulls with something else (a ? for example).