MSSQL ISNULL good function to replace null values

MSSQL has a nice function to replace null values conditinally

ISNULL(columnName, newValue)

This function requires two parameter columnName and new value to be replaced in place of null.

This function help me alot to solve the problem at database level instead at the coding level.

Possibly related posts: (automatically generated)

This entry was posted on Tuesday, December 5th, 2006 at 1:38 pm and is filed under Database. 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.

3 Responses to “MSSQL ISNULL good function to replace null values”

  1. Vijay Khambalkar Says:
    June 4, 2007 at 5:13 am | Reply

    In mysql, we can use

    COALESCE(field,value)

    SELECT firstName, COALESCE(lastName, ‘Last Name Not Specified’) FROM info

  2. Diego Souza Says:
    March 6, 2008 at 1:34 pm | Reply

    Cool, exactly what I need.

    Thank You

  3. Greg Says:
    May 8, 2008 at 3:13 pm | Reply

    @Vijay Thanks for that comment. I was looking for an alternative for ISNULL since someone commented on one of my blog posts that I should use it. Unfortunately MySQL and MSSQL did the function differently and this is what I was looking for.

Leave a Reply