troubleshooting Question

SQL diacritics

Avatar of cbeverly
cbeverly asked on
Microsoft SQL Server
1 Comment1 Solution2704 ViewsLast Modified:
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

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros