Thank you.
>Update column value by itself when @Location is empty
>
>CASE WHEN @Location <> '' THEN @Location ELSE Location END
>
>>
>>I have a SQL Stored procedure where a certain value is passed as character, as follows:
>>
>>
>>@Location char(20) = '',
>>
>>
>>Then the store procedure should update fields of a table; one of the fields is Location. But the field Location should be updated only if the passed variable @Location has value (not empty).
>>
>>Can I do it in one SQL Command (instead of using IF)? That is, how would I change the following expression?
>>
>>update MyTable set Field1 = @Field1, Field2 = @Field2, Location = @Location where Table_pk = 12
>>
>>
>>TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham