>>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.
Your way and my example are the only ways I know of. If you are not just browsing the results and are binding the fields to controls, you can modify your classes to set the NullDisplay property. I would put a DO CASE in the class Init to handle all the data types and what you want their NullDisplay values to be.
Mark McCasland
Midlothian, TX USA