On Thursday 15 April 2004 15:58, Bruce Momjian wrote: > > OK, so we need a list of columns for output with quotes, and a list of > columns where NULL should be changed to zero-length strings. > > How about if we use FORCE to force quotes on output, and CONVERT to > convert null to zero-length strings on input?
How about FORCEQUOTES and NULLTOBLANK which tells you what they will do? -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
