>Hi Thanks for your replies.
>My Sql select lloks like:
>Select * from TableA Left Outer Join Tableb on Key=Keyb.......
>I was trying to avoid having to get into inserting specific Filed names into the Select statement.
>If there was a Global setting like Set Nulls to Zero/Blank, it would mean I would not have to identify each field separately.
>regards,
>Gerard
>
There is no special setting that will convert NULL to empty value for you. The only way is to do it by modifying each field or, alternatively, you may try
select * from TableA INNER JOIN TableB .. where 1=0 into cursor newTable
set NULL off
insert into NewTable select myActualSelect
--------------
Not tested, though - may not work.
If it's not broken, fix it until it is.
My Blog