1

I'm using input tables with special chars, but my output tables need to be without them. So i need function that would replace special chars in query or table for example

Š=S Č=C Ć=C Ž=Z

Any sugestions?

Erik A
  • 31,639
  • 12
  • 42
  • 67
Marko Pantic
  • 91
  • 2
  • 9
  • 1
    This may help http://stackoverflow.com/questions/4024072/how-to-remove-accents-and-all-chars-a-z-in-sql-server – Fionnuala Mar 11 '14 at 10:03

2 Answers2

0

You could pop them into a string, and then use Replace, e.g. strYourString = Replace(strYourString, "Š","S").

Downside of this approach is you'd need to specify all the special characters you want to replace, and run the code several times, perhaps as a loop.

Sinister Beard
  • 3,570
  • 12
  • 59
  • 95
0

Replace function does that but (as far as I know) for single character: Expr1: Replace([Employees].[Prezime];"č";"c") For a fast but not efficiant solution you can create several fileds named Expr1, Expr2 Expr3, and in each remove one special character. But I am searching for more "decent" solution.

Vedran
  • 41
  • 1
  • 10