>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.