0

I want to display one table format report using ssrs. In my data set one column data type is var-binary. How to convert this var-binary datatype to string using expressions?

Sridhar
  • 21
  • 3

1 Answers1

1
SELECT CONVERT(VARCHAR(1000), varbinary_value, 2);

As per varbinary to string on SQL Server

Community
  • 1
  • 1
Snowlockk
  • 451
  • 2
  • 7
  • Thank you for your Response snowlock.But how can i use this conversion in expressions(fx) to display this field in ssrs report. – Sridhar Feb 24 '17 at 13:56
  • 1
    Convert it in sql and pass it through as Varchar. – Snowlockk Feb 24 '17 at 14:38
  • Thank you Snowlockk but i have restriction to convert this in sqlserver side.I have to do this conversion in reporting side. – Sridhar Mar 13 '17 at 14:20