SQL Server notes

Problem 1: This red symbol has never been seen before. Try to paste these symbols into notepad and find it garbled, try to paste it into the SQL query analyzer and find it blank. For such data, I always wanted to find this acsi code, and then the problem was solved. As a result, I found a lot of related information, none of which

Problem 1: This red symbol has never been seen before. Try to paste these symbols into notepad and find it garbled, try to paste it into the SQL query analyzer and find it blank. For such data, I always wanted to find this acsi code, and then the problem was solved. As a result, I found a lot of related information, none of which

Question 1: remove the red mark

I have never seen any red symbols. I tried to paste these symbols into notepad and found it garbled. I tried to paste it into the SQL query analyzer and found it blank. For such data, I always wanted to find this acsi code, and then the problem was solved. As a result, I found a lot of relevant information, and there was no similar problem. Finally, the straight-line thinking method is used to directly stick the character to the window of the SQL query analyzer. The solution is as follows:

SELECT
[F0L_MID],
Ltrim (rtrim (REPLACE ([F0L_MID], '','')
FROM [pfvaults]. [dbo]. [omegaults]

The problem can be solved. If any expert meets the red character, please share it with others to see what the problem is.

Filter out the special characters marked with red before and after the FOL_MID string, the result set starting with a space or ending with a space (note the condition after the where)

SELECT
[F0L_MID]
FROM [pfvaults]. [dbo]. [omegaults]
Where
[F0L_MID] like '%' or
[F0L_MID] like '%'

Zookeeper