Null???

[nexxus]

1st time working with Progress!
Im pulling data using DecisionStream by Cognos. I need NULL fields to have 'NONE'.
When i'm trying to execute IFNULL (To_Char (cc_ctg), 'NONE'....... it's not working.

Please explain what should i do or if there is a script that i dont know.
I cant use update table, I need NULL fields to have NONE while i executing SELECT statment .



Thank-you for your HELP!!!!

 

[tomeng01]

You are correct, ISNULL (To_Char (cc_ctg), 'NONE') is not being translated properly to Progress in the SQL engine.

Try: COALESCE(To_Char (cc_ctg), 'NONE')

Some programmers even prefer COALESCE to ISNULL

I hope it helps.