Skip to content
Advertisement

searching for and updating a wildcard/unicode chacracter using SQL

I have a string stored in a SQL databse that contains a wildcard unicode character followed by whitepsapce before the text I suspect in an attempt to try and mock right to left text and I need to remove the wildcard character however attemptng to search for the characters with a like clause does not locate it correctly.

I have tried using the square brackets method too combined with the like clause and this returns to me nothing. I have hundreds of these that I need to update.

The character is actually viewed as a small box with a question mark inside of it although when copied and then pasted it’s simply small box as per the example above.

The above query currently does not update the value by removing the unwanted character.

Is there any way to replace this wildcard chracter using only SQL?

Advertisement

Answer

looks for the substring '%%'. This does not exist in the string however. You want

instead. This replaces all '' with blanks.

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement