'How remove non numeric numbers using filter String in Data Grid View?
I am trying to remove all non numeric from data view grid in VB using filter string. I am not entirely sure if this can be possible using filter string but my current code is as follows:
ftext &= String.Format("TRIM(mobile) LIKE '{0}{1}%'", If(optContains.Checked, "%", ""), awSQLFilterLike(fFilter.Text))
Please not some of the data I have in the database is like "0535723 Cyaon" etc. So how possibility an I remove non numeric numbers.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|