Thanks Ryan

😀

Compiled this function and tried to run it against AdventureWorks database.

Got error:

Msg 208, Level 16, State 1, Line 1

Invalid object name 'Tally'.

:crying:

So if I want to find only Names with non0latin characters - I should use this SQL?

select *, dbo.IsHighAscii(TheName) As HasHighAscii from names where HasHighAscii = 1

How can I add apostrophe to this expression - char(39)?

For example, I should select all alpha-numeric name. However, some names contains apostrophe, like O'Brien.

select * from YourTable where YourColumn like...