replace field value using wildcard
Posted on 2014-02-22
How can I replace a string value that uses a wildcard? For example, I'm trying to update a field on a table and replace the field value where it starts with a specific two character pattern followed by any series of characters and just replace it with just a two character pattern. Something like this:
UPDATE myTable SET myField = REPLACE(myField,'XX%','XX')
But, the above doesn't work?
Any help is appreciated.