'What is the special character VT? I need to replace it from MS SQL

Somebody left this special character in the SQL table

It more looks like ♂ sign but thinner or a vertical tab Char VT sign, but when I copy it to word document or SQL query page it displays like a white space. Only Notepad++ configures it as VT sign. I tried to copy that sign to google search bar but what I saw is only a white space.

I wonder it must come from different language keyboard or something I have no idea what's about.

Anyone recognize it?

---------------update--------------------

I found out this special character doesn't display in here correctly. I added a picture here

sqlspecial-characters


Solution 1:[1]

Represent the VT (vertical tab) character as a Transact-SQL string with char(11).

Almost any keyboard will send this character with CtrlK.

Solution 2:[2]

Using python:

<str_value_with_VT>.replace((b'\x0b').decode(),"")

Solution 3:[3]

Replace(columnName, char(11), '')

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 Nick stands with Ukraine
Solution 3 Xavier Guihot

Related Questions