Search code examples
t-sqlsql-server-2000replace

replacing special characters in SQL 2000

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

Thanks

Solution

  • 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.