Post reply

string to NULL

  • October 30, 2009 at 1:09 pm

    #135897

    Hi all,

    I have a question

    I want to check for string value and replace it with NULL is it possible in derived column??

    if column1 is 'abc'

    then make column1 to NULL

    else column1

    thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • October 30, 2009 at 1:42 pm

    #1073361

    Yes, it's possible.

    Use a Conditional to test the value of your column. If it = "abc", then you'll need to use a combination of a Type Cast and a NULL function to create a null value that matches the data type of the column.

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

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