Jul 18, 2017

How to remove invisible characters in MS SQL (MS SQL 줄바꿈, 텝문자 제거하기)


Invisible characters in MS SQL

Tab : char(9)
Line feed : char(10)
Carriage return : char(13)

ex : remove 'tab' : replace([column name],char(9),'')

No comments:

Post a Comment