>>Hi,
>>
>>Is there a way to convert the NULLs in fields to their respective empty values in the resulting view from an SPT command?
>>
>>Any help is greatly appreciated.
>>
>>TIA,
>>Arriyel
>
>
>select nvl(fname, space(30)) LastName...
I was looking for a more generic solution. I have a lot of SQL pass through calls/statements and was trying to avoid modifying all of them to handle the NULLs. I even have one SPT command that has over 200 fields.
I do have a Null2Mt procedure that goes through all the fields of a table and converts the NULLs to their respective empty values. Only thing is it seems to have a problem with the fields not having the propertype i.e. nField1 is type "C" when it should be type "N". And I haven't had time to debug it properly due to upcoming deadlines.
Thanks,
Arriyel
Speak using soft and sweet words in case you have to eat them later.