0

Possible Duplicate:
How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?

Let's say I have in my column text:

"some text ... España .. some text"

Is it possible to write query which returns me this row even if I write:

where dataColumn LIKE N'%espana%'

I have limited number of special characters that I have to ignore

thanks for any help

Community
  • 1
  • 1
gruber
  • 28,739
  • 35
  • 124
  • 216
  • 1
    Depends on your collation - what collation does your database (and this column) have? You can make a collation **accent-sensitive** or **accent-insensitive** ... – marc_s Oct 03 '12 at 14:18
  • OP: could you spend some time learning how to format your questions: http://stackoverflow.com/editing-help - it's a wee bit unfair to expect the community to fix them every time you ask a new question. Thanks. – Kev Oct 03 '12 at 23:33

0 Answers0