How to check if string is in column value of returned DataRow array in C#?
<p>I know this is very basic, but I can't seem to get it right. I have this datatable that I will fill with processed information from my database. </p>

<p>After searching if the EmpRequestID has already been added in the Datatable,  I want to be able to get the value of the column named "RequestedEmp" of the returned row and check if already contains the initials that my variable is currently hosting (it is in a loop). If it does not, append the initials in the variable in the existing initials in the row. </p>

<pre><code>DataRow[] MyEmpReq_Row = MyEmpRequests_DataTable.Select("EmpRequestID='" + EmpRequestID + "'");
int SameReqID = MyEmpReq_Row.Length;

if (MyEmpReq_Row &gt; 0) //REQ ID IN DT, MULTIPLE EMP 1 REQUEST
{
    //INSERT HERE 
}
else //ID NOT IN DT YET
{
    MyEmpRequests_DataTable.Rows.Add(EmpRequestID, ActionBy, Requested_Initials, DateSubmitted, RequestStatus);
}
</code></pre>

<p>I want to be able to do something like this</p>

<pre><code>string RetrievedInitials = MyEmpReq_Row["RequestedEmp"].ToString();

if (RetrievedInitials LIKE '%" + Requested_Initials + "'") // but if statements doesnt have LIKE
</code></pre>

<p>or this and then know if the column contains the value or not. </p>

<pre><code>MyEmpReq_Row.Select("RequestedEmp LIKE '%" + Requested_Initials + "'");
</code></pre>
