David Burrows (12/19/2013)
DECLARE @test-2 varchar(max)
SET @test-2 = CHAR(1)+CHAR(87)+CHAR(179)
SELECT CAST(CAST(SUBSTRING(@test,1,3) as varbinary(3)) as int)
how do u made CHAR(1)+CHAR(87)+CHAR(179) on which factor u decide if it is a dynamic one then how will u do
how to do it for vice versa...
Thanks for your suggestion..!