Changing values with another value

Question

Hi,
I have a simple query that getting some datas like below;

ID , Month 
1       5
2       12
3        3


For example I want to change "Month" column's value. For example if there is 1, and I'll show with January. And if there is 12, I'll show December.

How can I do that with MSSQL?

Regards.

Answer 1

First of all be sure that you are importing/using (depending on language) the System.IO namespace for this to work. But what you can do is something like this

string pathToCreate = "~/UserFolders/" + TextBox1.Text;

if(Directory.Exists(Server.MapPath(pathToCreate))

{

   //In here, start looping and modify the path to create to add a number

   //until you get the value needed

}

 

//Now you know it is ok, create it

Directory.CreateDirectory(Server.MapPath(pathToCreate));