Filtering rows from DataTable

[ArunDhaJ]

Hi All,
I've a DataTable with one column as PhoneNumber. The phone number is
stored as
(111) 222-3333. I need to filter the DataTable. the filter expression
could be 1112223333 or 2233 or 112. Any of these search critera should
filter the phone number

i need to perform filter like this
System.Data.Dat aRow[] objDataRows = objTable.Select ("PhoneNumbe r like
'1112223333');
or
System.Data.Dat aRow[] objDataRows = objTable.Select ("PhoneNumbe r like
'23333');
or
System.Data.Dat aRow[] objDataRows = objTable.Select ("PhoneNumbe r like
'1122');

I need to format the PhoneNumber column. Like before searching i need
to convert phone number from (111) 222-3333 to 1112223333

Is there any way to format the column before searching ??? I expect a
statement like this
System.Data.Dat aRow[] objDataRows =
objTable.Select ("Format(PhoneN umber) like '1122');

Please help me to sort out this problem.

Thanks in Advance
-ArunDhaJ