How to remove unwanted ASCII character in a SQL column

[benchpolo]

I have a column that holds a character 'à', and I'm not able to filter this out from TSQL query.

Data Sample: PCP12345à

Code: LTRIM(RTRIM(REP LACE,REPLACE(cm .provid,' ',''),'à',''))

Thanks.

[ck9663]

Try using the char function. Something like:

replace(cm.provid,char(133),'')

Happy Coding!!!


~~ CK

[benchpolo]

okay i figured it out.. I have layers of query.. i should've used the replace(cm.prov id,char(133),'' ) in the first layer instead of the last layer. Thanks for the tip ;)