Home Forums SQL Server 7,2000 General Convert ASCII RE: Convert ASCII
Antares686
SSC Guru
Points: 125444
More actions
May 9, 2003 at 4:14 am
#456641
I am pretty srue there is a proper conversion however I cannot seem to find it right off. But here is a way that will work
DECLARE @S as VARCHAR(2)
SET @S = '4F'
EXEC('SELECT ASCII(CAST(0x' + @S + ' as varbinary(1)))')