Friday, February 10, 2012

BIT help

I need to conver numbers from base 16 or 10 to 2 . For example if you now a function to convert 15 to F or 15 to 00001111.
I need sql function if exists .
Thanks for help.select case when @.i < 10 then convert(varchar(1), @.i) else char(ascii('A') + @.i - 10) end

No comments:

Post a Comment