MS SQL: “if null then zero”

Problem:

Query nam vraća null, a nama treba nula

Rješenje:

Select coalesce(fieldName,0) as broj

ili

Select (case when fieldName is null then 0 else fieldName end)) as broj

ili

Select (IsNull(fieldName,0)) as broj
This entry was posted on Tuesday, April 5th, 2011 at 11:51 pmand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.