Convert the Binary data type to string data type

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

  • You should be able to cast it.

    declare @tst varbinary(20)

    Set @tst = 0x74657374

    Select cast(@tst as varchar(20))

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply