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

Niradhip Chakraborty · Answer

Try This: DateTime dtmMechCode = Convert .ToDateTime( DateTime .Now); string strMechCode = Convert .ToString(dtmMechCode).Replace( /   ).Replace( :   ).Replace(     ).Replace( AM   ).Replace( PM   ); string UniqueId = RE + strMechCode;