replace square character

there is a square character

it is not visible selecting to sql server 2005 grid

but it is visible  when using microsoft excel
LVL 1
rgb192Asked:
Who is Participating?
 
Rajkumar GsSoftware EngineerCommented:
0
 
Reza RadConsultant, TrainerCommented:
0
 
Anthony PerkinsCommented:
It is more than likely a CrLf or Cr or Lf.  Use the T-SQL CHARINDEX() function to IDENTIFY and REPLACE() function to remove it.
0
 
rgb192Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.