ê, ç, á, ã, ó,á

Anybody, by chance, does have or did it already elaborate some script that
substitutes all the special characters of a base of Customers for instance
(ê, ç, á, ã, ó,á...), and does it can me to help as doing that?You can create a table with these special characters and with which
character you want it replaced.
For example:
CREATE TABLE CharacterReplacements
(OriginalChar nchar(1) not null primary key
,ReplacementChar nchar(1) not null
)
INSERT INTO CharacterReplacements VALUES (N'ê',N'e')
INSERT INTO CharacterReplacements VALUES (N'ç',N'c')
Declare @.mytext nvarchar(100)
Set @.mytext='Comment ça va?'
SELECT @.mytext = Replace(@.mytext, OriginalChar, ReplacementChar)
FROM CharacterReplacements
SELECT @.mytext
Hope this helps,
Gert-Jan
Frank Dulk wrote:
> Anybody, by chance, does have or did it already elaborate some script that
> substitutes all the special characters of a base of Customers for instance
> (ê, ç, á, ã, ó,á...), and does it can me to help as doing that?