replacing special characters in SQL 2000

Question

Hi, how can I replace special characters in my data files (special characters such as bullet points, percent sign, hyphen etc) ?

Thanks

Answer 1

You can use T-SQL REPLACE:

REPLACE(FieldWithStars,'*','STAR')

For more than one substitution you could use cascading REPLACE statements.

No clue though about bullet points - but you should be able to replace anything looking for the right escape sequence for that particular character.