Happy New Year in TSQL

I did use SQL String manipulations a lot this year. I want to show an example of how to use CHAR.

Open your Management Studio – and paste the following in your Query Window

SELECT CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15) + CHAR(15) + CHAR(15) + CHAR(15) + CHAR(13)
+ CHAR(72) + CHAR(65) + CHAR(80) + CHAR(80)+ CHAR(89) + ' ' + CHAR(78) + CHAR(69)+CHAR(87)+ ' ' + CHAR(89)+ CHAR(69)+ CHAR(65) + CHAR(82)
+CHAR(13)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15)+CHAR(15) + CHAR(15) + CHAR(15) + CHAR(15)

Run the Query(Try Pressing Ctrl-T and run the Query again).

Want to know what each CHAR value represent ?
Run the following:
  

DECLARE @i int
SET @i = 1
WHILE @i < = 256 Begin PRINT CHAR(@i) + ' --> ' + CONVERT(VARCHAR,@i)
SET @i = @i + 1
END

Enjoy!!!

Wish you all a Happy New Year.

@VivekSerou

Posted December 31, 2009 by Vivek. Comments and trackbacks are open. Follow the comments feed.
Filed under:
Tagged with: .

Leave a Reply

←
→