Delete Last Character

Question

StringX Varchar(30);

StringX is not a column in a table .

I have StringX = 'He is Teacher , '

How I can delete the last char ( , )?

Answer 1

You can use rtrim for that:

select rtrim(StringX, ', ')
from   tabkeName

Also note you have a space before and after the ,, so you need both , and in the rtrim call.