diverse null values using nullasvalue for diverse columns

[ali_hijazi]

Hello

I know that we can make null values selectable by using the NULLASVALUE

NULLASVALUE Field1;

SET NULLVALUE =''

what if I want to give "-" for null values for another field say Field2 what would be the syntax?

[aveeeeeee7en]

Do this in your Script where Field2 is lying in your table and create a new field.

if(Len(Trim(Fied2))>0,Field2,'-') AS NewField2

Regards

Aviral Nag