I am having the value in column 1 - 12 digits saved as per the selected month, While fetching the data I need to show the month name in select statement.. Please help ASAP Need DB2 Query SELECT (SELECT MAX(BAUKID) FROM CRPDTA.F58SM039 ) AS RMAX ,BAUKID AS ID ,BADO AS DOCODE ,BAAA AS AMOUNT ,BAOBSZ AS NOOFJOBCODE ,BAS1FU AS EMPPOSNAME ,BAFB03 AS EMPCATEGORY ,BAMNTH AS MONTH ---(Here I need month name ,BAMNTH this contain any number in 1 to 12 ) FROM CRPDTA.F58SM039

GBD

MailMessage emailmsg = new MailMessage();
string ids="aa@gamil.com,bb@gmail.com";
string[] mailIDs = .Split(',');

            emailmsg.From = new MailAddress("ganeshbdas1@gmail.com", "name of email");
            foreach (string id in mailIDs)
            {
                emailmsg.To.Add(new MailAddress(id, id));
            }
            string\[\] stringAM = { "AM" };
            emailmsg.Subject = "";

            emailmsg.Body = "";
            emailmsg.IsBodyHtml = true;
            emailmsg.Priority = MailPriority.Normal;
            SmtpClient mailclient = new SmtpClient("smtp.bizmail.yahoo.com");

            mailclient.Credentials = new System.Net.NetworkCredential("ganeshbdas1@gmail.com", "password");
            mailclient.Send(emailmsg);