Question one: This red symbol is taken off
Have not seen the symbol of red, try to paste these symbols out to Notepad found it is garbled, try to paste it into SQL Query Analyzer, found that it shows blank. For such data, always want to find this ACSI code, then the problem is solved. The results found a lot of relevant information, there is no similar problem. Finally, using straight-line thinking, directly simply put that character into the SQL Query Analyzer window, the solution is as follows:
SELECT
[F0l_mid],
LTrim (RTrim (REPLACE ([F0l_mid], ","))
from [Pfvaults]. [dbo]. [OMEGAFLD]
Problem to solve, which master if you meet the red character, but also to share, see what it is
Filter out the special characters of Fol_mid string before and after the red, starting with a space or ending with a space (note the condition after where)
SELECT
[F0l_mid]
from [Pfvaults]. [dbo]. [OMEGAFLD]
where
[F0l_mid] like '% ' or
[F0l_mid] like '% '