Post reply

Null comparision using sql

  • November 5, 2011 at 6:32 am

    #245688

    Hi,

    I need to compare sql table field . if field is not null concatenate 'BY: thenmozhi' , if field is null i need to return empty field ..

    how i will write sql query

    Thanks

  • November 5, 2011 at 6:41 am

    #1403608

    You cold use the COALESCE function for example:

    DECLARE @v-2 VARCHAR(5)

    SET @v-2 = NULL

    --returns a blank ---returns the asterik

    SELECT COALESCE(@v,' '),COALESCE(@v, '*')

    A better example:

    DECLARE @v-2 VARCHAR(5)

    DECLARE @W VARCHAR(5)

    SET @W ='B'

    SET @v-2 = NULL

    SELECT COALESCE(@v,' '),COALESCE(@W, ' ')

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • November 5, 2011 at 6:57 am

    #1403610

    Hi bitbucket,

    Thanks a lot... its working...

    🙂

  • November 5, 2011 at 7:09 am

    #1403613

    sthenmozhi14 (11/5/2011)

    Hi bitbucket,

    Thanks a lot... its working...

    🙂

    Your welcome and thanks for letting me know ....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

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

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