convert function

If this query got resolved then please Accept the post that helped you as Answer.

So other members can easily find the answers.

Suthish Nair15y ago

refer the links i posted here and rework your code.

http://www.c-sharpcorner.com/Forums/UploadFile/105796/

krithika muthukrishnan15y ago

in asp.net how can i convert varchar to varbinary using convert function

Vijay Yadav15y ago

Hi Krithika,

you can do like this:
DECLARE @X varbinary(20)
Set @X = CAST('Testing' As varbinary(20))
Select @X As [varbinary], CAST(@X as varchar(20)) As [varchar]

Thanks,
Vijay