Post reply

Replacing ASCII Characters with other ASCII Characters in a table

  • July 19, 2007 at 8:55 am

    #179829

    Hi

    I'm trying to view all resourcenames which contain ASCII charaters of 224 to 229 from the table Resources

    select * from resources where resourcename  'contains' <= char(224) and resourcename 'contains' >= char =229)  

    And I also want to replace all the ASCII charaters between 224 and 229 (in the resource names) with ASCII character 97... How do I do this..?

    Help!!

  • July 19, 2007 at 2:10 pm

    #720909

    select * from resources where resourcename LIKE '%[' + char(224) + char(225) + char(226) + char(227) + char(228) + char(229) + ']%'

    update resources

    set resourcename = replace(replace(replace(replace(replace(replace(resourcename, char(224), char(97)), char(225), char(97)), char(226), char(97)), char(227), char(97)), char(228), char(97)), char(229), char(97))

     

    N 56°04'39.16"
    E 12°55'05.25"

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply