I have a tables in SQL Server and some of the values in the varchar column contain C1 control characters https://en.wikipedia.org/wiki/C0_and_C1_control_codes#STX

When I copy the value into notepad++, I get:

and when I read in python, I get 'Tylerâx80x99s way'

I can remove x80x99 and write back to SQL, but this causes downstream issues, as the values are not the same.

I would thus like to search for the x80x99 in the varchar column and replace, but running this query

select * from tableName where AddressLine2 like  '%x80%'

return 0 rows, when I know there should be 49 rows – see apostrophe-like character appears in DataFrame as ‘âx80x99’

How can I search for this specific character, as https://www.mssqltips.com/sqlservertip/6022/sql-server-char-function-and-reference-guide/ does not show the correct char() mapping