Trimming a string

[edojan]

Hi

I have a table audit

AUDIT_QUEUE
RESC
Pre Ex
COB
RESC-x
Pre E-x-x-x
COB-x-x-x-x

What i want is a query or code so that it reads the field and strips away all "-x" there might be more then 1 instance of -x in there so need to remove all of them. How do i do this?

Thanks

 

[Rabbie]

If the -x is always at the end of the string you just need to loop round removing the -x each time until there is none left

 

[boblarson]

Look into using the Replace function to specify the -x and replace with ""

 

[edojan]

Thank YOU!!!