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

Since majority of my customers still use SQL 2008 (and one is still using SQL 2005) I won't use IIF() in my code. But I am making mental note for the future.
Thank you.