Post reply

A way to make something NOT NULL in a select query

  • December 15, 2004 at 6:19 am

    #74815

    Other than setting ANSI_NULLS to on/off, is there a function I can use which automatically 'un-nulls' anything that is null, for the purpose of a select query?

    Right now I have employed some CASE statements, which check to see if something is NULL. If so, the select query gives a character in place, otherwise the entire query is a NULL!

     

    Thanks

  • December 15, 2004 at 6:35 am

    #533928

    ISNULL or the ANSI equivalent COALESCE might help you.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply