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