Hi,
I've to filter rows from DataTable Select
There is a column named "Phone" which contains values in the following
format:
(901) 789 1234<BR>(901) 789 1235<BR>(901) 789 1221
I need to filter based on the phone number. the search criteria could
be 9017891221 or 891221.
this string should filter the above column
I've tried in SQL be replacing the '(', ')' and spaces as
9017891234<BR>9 017891235<BR>90 17891221
and performed search. It worked fine..
When i tried in Select method gives Unknown Function
REPLACE() error
I've used
REPLACE(REPLACE (REPLACE(Phones , ' ', ''), '(' , ''), ')', '') like
'%891221%'
Is there any way to achieve the same to filter the data?
Thanks in Advance
- ArunDhaJ