failrly easy to generate your own table of ascii chars, but i don't understand what you meant by from mulitple columns;
can you explain what you were after?
here's one example:
with Tally (N)
AS
( select top 127 row_number() over (Order By Name) from sys.columns
)
select N-1 as CHARVALUE,CHAR(N-1) as ASCIICHAR
from Tally
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!