>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
As usual Sergey has given you an excellent solution.
If you want a more VFP-like solution, I was pleased to learn recently that SQL server 2012 and later supports IIF(), with a syntax exactly like VFP's.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.