null

js · Feb 22, 2005

hi, how to convert null to empty string in a query? thanks.

John Spencer (MVP) · Feb 22, 2005

Use the NZ function.

Nz([Some Field],"") as NotNullField

JohnFol · Feb 23, 2005

iif(isnulll (MyField), "", MyField)

or

select MyField & "" from .. . . .