Code: Select all
select EVAL "CONVERT(@TM:@VM,'.', Field1:'-':Field2:'-':Field3) from H_TABLE;
So I applied the above null check condition to each of the fields, if it is null, then the output is empty string else it is the same field.
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;
I tried different approach using @NULL.STR(below), but it doesn't work either.
Code: Select all
select EVAL "CONVERT(@TM:@VM,@NULL.STR,'.', Field1:'-':Field2:'-':Field3) from H_TABLE;