Chracter codes in sql 'like' queries?

Question

I put some data that I have in my database. One of the files was somehow corrupted or something - it randomly has a symbol with a value of 6, ACK , in different unexpected places instead of real letters. This causes me various duplication problems in my database and so on - for example, one company has two records in my database, one like Afh Engineering Ltd. and the other as Afh Engineerin Ltd. (SO can clear this character - basically 'g' is replaced by the ACK character.)

I want to make a request for all companies in my database that have this problem. Sort of:

 select * from users where CompanyName like '%06%' 

but obviously for a character with a value of "6", and not for a character representing the Indo-Arabic numeral "6".

How to do it?

Answer 1

 SELECT * FROM users WHERE CHARINDEX(CHAR(6), CompanyName) <> 0