Hey Anuganti,

See if I understand you correctly the belwo would fit your requirement

CREATE FUNCTION dbo.GetAsciiValue

(

@STR varchar(100)

)

RETURNS varchar(1000)

AS

BEGIN

DECLARE @res varchar(1000)

SELECT @res=COALESCE(@res,'')+CAST(ASCII(SUBSTRING(@str,number,1)) AS varchar(5))

FROM master..spt_values

WHERE type='p'

AND number BETWEEN 1 AND LEN(@str)

RETURN @res

END

then use it like

select name,number,dbo.GetAsciiValue(number) AS AsciiEqv

from yourtable