Hello,
I am trying to remove the last character in the field if it is a comma. I have this code written so far but when I run it, instead of just removing the "," in the field it removes the text in the whole field. If you can help me out I would appreciate it.
UPDATE New_Users SET New_Users.Ready_To_Sell = LEFT(Ready_To_Sell, LEN(Ready_To_Sell - 1)) WHERE Right(New_Users.Ready_To_Sell,1) = ',';