r trim of characters other than space

["surabhi.ahuja" <surabhi.ahuja@xxxxxxxxxxx>]

Hi 

hi i have varchar type fiels in a table.

 

i want to make the following check,

 

if it is having carets in the end, then those carets be removed.

 

so if i get a string like abc def^^^^

 

i should be able to get abc def

 

how should i do this.

 

thanks,

regards

Surabhi