SQL question 1

[gerito]

How can I do something like this:

"UPDATE _table SET _c = (REPLACE(_c, '±', 'ñ') REPLACE(_c, 'ß', 'á') REPLACE(_c, '¾', 'ó'))"

because this code is erroneus.

Thanks and greetings.

 

[disord3r]

I think it's beacuse you can't string together a bunch of REPLACE functions like that. Try it like this:

UPDATE _table SET _c = (REPLACE(REPLACE(REPLACE(_c, '¾', 'ó'), 'ß', 'á'), '±', 'ñ'))

 

[gerito]

Thanks a lot

 

[GlenJohnson]

Just curious, why didn't you post this in the sql forum? Glen A. Johnson
Johnson Computer Consulting
MCP W2K
glen@johnsoncomputers.us



"There is only one good: knowledge; and only one evil: ignorance."
Socrates (470- 399 BC); Greek philosopher.