PRINT CAST(0x5052415645454e AS VARCHAR(7))

It will display ‘PRAVEEN’ :)

VN:F [1.1.6_502]
Rating: 0.0/5 (0 votes cast)
Share:
  • Digg
  • del.icio.us
  • Facebook
  • Google
  • DotNetKicks
  • LinkedIn
  • Live
  • MySpace
  • StumbleUpon
  • Technorati

Related posts:

  1. Build DateTime from values
  2. SQL Server CURSOR - loop through records
  3. T-SQL Find previous month
  4. What is the difference between CAST and CONVERT in SQL?
  5. SQL – Convert columns to a row (concatenation)