nvl equivalent in uvsh

[tostay2003]

Is there any nvl equivalent function to use in select queries of uvsh. Basically want to replace all null with an empty string.

[ray.wurlod]

Code: Select all

EVAL "IF ISNULL(column) THEN '' ELSE column"

[mystuff]

Code: Select all

EVAL "IF ISNULL(column) THEN '' ELSE column"

I have a similar usage in select query involving convert as well. Something like this

Code: Select all

select EVAL "CONVERT(@TM:@VM,'.', Field1,Field2,Field3) from H_TABLE;

If any of the fields is null then the output is null.

I applied the above null check condition.

Code: Select all

select EVAL "CONVERT(@TM:@VM,'.', If Isnull(Field1) then '' else Field1,If Isnull(Field2) then '' else Field2, If Isnull(Field3) then '' else Field3) from H_TABLE;

But, whenever Field2 is null, Field3 doesn't get displayed irrespective of whether it is null or not. I do get the output though i.e. only Field1 gets displayed with field seperators until Field2.

[ray.wurlod]

This is unrelated to the original question. If you have a new question please begin a new thread.