I use sql server 2000 and I'm hoping someone can help me.

I inherited a system that controls some layouts of webpages through a database. One table has a NumberOfCols field that contains the information for the number of columns in the layout. What I'm looking to do is return the value "A" if the number is 1, "A,B" if the the number is 2, and "A,B,C" if the number is 3.

A simple query to return the data would be

SELECT NumberOfCols
FROM template
WHERE cid = 100 and sid = 2

I assume you would use some IF's but I'm unsure how.

Thanks