Removing last Character if it is a comma

[MTSPEER]

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) = ',';

[pbaldy]

I think it should be:

...LEN(Ready_To_Sell) - 1)

Pin other words, the minus 1 outside the Len() function.

[alansidman]

Spend ten minutes looking at this video and you should be able to achieve what you want.

http://www.datapigtechnologies.com/f...anipulate.html

[MTSPEER]

Woot! Thank you pbaldy!

[pbaldy]

Happy to help!