I am trying to write an update statement that will put a null in a field if the variable input is blank.
for example
UPDATE x = var1,
y= var2
FROM table
WHERE .....
The user types in 'S' for variable 1 and they leave variable 2 blank. How can I get it update x to 'S' and y to null?