CHAR(CAST(0x3A as int)) : CHAR « String Functions « SQL Server / T-SQL

1. SQL Server / T-SQL
2. String Functions
3. CHAR

CHAR(CAST(0x3A as int))

1> SELECT  CHAR(CAST(0x43 as int)) + CHAR(CAST(0x3A as int)) +
2> CHAR(CAST(0x5C as int)) + CHAR(CAST(0x50 as int)) + CHAR(CAST(0x72 as int))
3>    + CHAR(CAST(0x6F as int)) + CHAR(CAST(0x67 as int))
4>    + CHAR(CAST(0x72 as int)) + CHAR(CAST(0x61 as int))
5>    + CHAR(CAST(0x6D as int)) + CHAR(CAST(0x20 as int))
6>
7> GO

-----------
C:\Program

(1 rows affected)
1>
           
       

Related examples in the same category