Select Case in Stored Procedure

[jbooth]

Is it possible to use the select case statement in SQL Server 6.5 in a stored procedure. I have a table with a field for every month in the year. I want to just populate one field in the table for a particular month that is chosen from a drop down box in my application. Is this possible or am I going in the wrong direction

[JHausmann]

Not sure the case statement is what you want to use. From what you've posted, it sounds like you either want to use a stored procedure (with parameters) or build a SQL "update" statement on the fly.