Convert the Binary data type to string data type

• satheesh-356918

  SSC Journeyman

  Points: 98

  More actions

  July 23, 2008 at 5:17 am

  #94318

  i need to convert the Binary data type to text datatype how it is possible... if any one tryed on this let me know..

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  July 23, 2008 at 5:23 am

  #846918

  You should be able to cast it.

  declare @tst varbinary(20)

  Set @tst = 0x74657374

  Select cast(@tst as varchar(20))