Link to home
Start Free TrialLog in
Avatar of cbeverly
cbeverly

asked on

SQL diacritics

Is there a way in sql to remove all diacritics of a field in a select statement i.e if the field called Name has diacritics such as Jiménez but I want them all stripped out is there a way to do it at the select name field level? I am able to get Collate Latin1_General_CI_AI to work at the where clause but not at the select statement.

select Name
from SomeFile




ASKER CERTIFIED SOLUTION
Avatar of DireOrbAnt
DireOrbAnt

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial