SQL: Replace Null values with Blank ""

[gautam89]

Hi everyone,

I have a a table called [Email Database] with many fields

I need to create a query that replaces all Null values with blanks or ""

I'm not that familiar with SQL so any help would be appreciated!

 

[SQL_Hell]

Hi there,

You need the NZ function, like....


SELECT NZ(email,"")
FROM [Email Database]


Also is your table actually called 'Email Database'? it is bad database design to have table names with spaces in them.