Do something like this
string search = String.Format("Convert(<column name="">,'System.String') LIKE '{0}*'", EscapeLikeValue(Search.Trim()));
DataView dv = new DataView(dt);
dv.RowFilter = search;
dt = dv.ToTable();
-------------------------------------------------------------------------------------------
public string EscapeLikeValue(string valueWithoutWildcards)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
for (int i = 0; i < valueWithoutWildcards.Length; i++)
{
char c = valueWithoutWildcards[i];
if (c == '*' || c == '%' || c == '[' || c == ']')
sb.Append("[").Append(c).Append("]");
else if (c == '\'')
sb.Append("''");
else
sb.Append(c);
}
return sb.ToString();
}