Home Forums SQL Server 2005 Development Convert the Binary data type to string data type RE: Convert the Binary data type to string data type

  • 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))