NVL() equivelent in Access (1 Viewer)

Chunk

Registered User.
Local time
Today, 09:13
Joined
Oct 25, 2004
Messages
64
In Oracle SQL, there is a function NVL() that allows you to test if something is null, and then if it is, replace it with a value of your choice.

I.e.

NVL(fieldOne, 0)

Is there an equivelent function in MS SQL, I have searched the internet, but cant find anything.
 

Chunk

Registered User.
Local time
Today, 09:13
Joined
Oct 25, 2004
Messages
64
Rich said:
Look up the Nz Function

Great. Just what I was after. Thanks.
 

Users who are viewing this thread

Top Bottom