How to count number of entries depending on the string in a field in sql

Question

I am having table Inbox in which i have two fields sender mailid and subject....
I should generate number of entries whose subject starts with "Re" for a unique mailid........


Please help me out in telling the query how to solve the above problem

Answer 1

Try This:
 

DateTime dtmMechCode = Convert.ToDateTime(DateTime.Now);

 

string strMechCode = Convert.ToString(dtmMechCode).Replace("/", "").Replace(":", "").Replace(" ", "").Replace("AM", "").Replace("PM", "");

 

string UniqueId = "RE" + strMechCode;