sql: compare 2 strings without considering accents and other stuff îăţş = iats (<-should be equal)

Question

I need to compare 2 strings in sql so that the word

"iast" would be equal to "îăşţ"

anybody knows how to do this ?

Answer 1

Just use an accent-insensitive collation for your comparisons:

IF 'iast'='îăşţ' COLLATE Latin1_General_CI_AI
PRINT 'YES'

For more info go through this link

Answer 2

  select 1 from Table_1
  where 'iast' = 'îăşţ' COLLATE Latin1_General_CI_AI