Thursday, August 7, 2008

How To Replace Null Value With The Custom Value

COALESCE ( expression [ ,...n ] )

Example :

SELECT COALESCE(FieldName,'0.00') FROM TableName;

If The Specified Field have null value it will be replace by 0.00 in the Result.

It's equivalent to Oracle NVL.



No comments:

Creative Commons License
Disclaimers:We have tried hard to provide accurate information, as a user, you agree that you bear sole responsibility for your own decisions to use any programs, documents, source code, tips, articles or any other information provided on this Blog.