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 this kind of data, have been thinking to find this ACSI code, then the problem is solved. The results found a lot of relevant information, there is no similar problem. Finally, the use of linear thinking, directly simply to paste that character into the SQL Query Analyzer form, the solution such as the following:
SELECT
[F0l_mid],
LTrim (RTrim (REPLACE ([F0l_mid], ","))
from [Pfvaults]. [dbo]. [OMEGAFLD]
Problem to solve, which master if you meet the red characters, but also to share, see what it is
Filter out the special characters of the Fol_mid string before and after the red, beginning 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 '% '