Post reply

checking secondary field and replace null value

  • October 10, 2007 at 11:24 am

    #70138

    This is what i try to do

    in our database the second address field, if not used will display a null or else it will display address info.

    First, when i run my query i want to check if that field is populated with address info and then display it in my output but if it is null then that part of the query must be ignore, almost like an if statement.

    thanks for the help

  • October 10, 2007 at 3:40 pm

    #741003

    SELECT

    CASE WHEN SecondAddress IS NULL THEN '' ELSE SecondAddress END

    FROM

    ......

  • October 10, 2007 at 5:30 pm

    #741028

    ....or -

    select isnull(secondaddress,'') as secondadd_notnull ,

    ....

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • October 11, 2007 at 8:06 am

    #741215

    Thank you...

Viewing 4 posts - 1 through 3 (of 3 total)

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