On 16 Jan 2004, Ashok Chauhan wrote: > > hello > > i am selecting ten fields form a table and i want to replace the null > values with any other value.
Look up coalesce(), it should do exactly what you need. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]