Post reply

how to update a variable with not null values

  • October 14, 2008 at 2:56 am

    #194306

    hi all,

    i want to update a variable with not null values whereas i have both null,empty,not null values in my table

    can anybody help me to solve this issue

    thanks in advance

    regards

    durgesh j

  • October 14, 2008 at 3:03 am

    #884480

    I think u will have to explain a little more with some code...

  • October 14, 2008 at 3:09 am

    #884485

    use IsNull, COALESCE functions, for more information, see SQL BOL.

  • October 14, 2008 at 3:11 am

    #884488

    hi ros,

    i have a transaction table

    col1 col2 col3

    a 1 a1

    b 2

    c 5 c1

    d 3 d1

    the output should be display in col2 order

    i mean order by col2

    In the following output there is no value for b(col1) bcoz its value in col3 is empty

    output:

    a:a1;d:d1;c:c1

  • October 14, 2008 at 4:27 am

    #884505

    Use isnull(col3,'') instead of a just col3.

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

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