FilterData Set eproblem VB.NET
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Cant use wildcards with "LIKE" accessing oracle database objDv = FilterDataSet(objDs, "SUPERVISOR_NAME LIKE 'se_n'") where objDs is the data set should return "sean" but is not not fimilar with wildcards any ideas? Cheers
-
Cant use wildcards with "LIKE" accessing oracle database objDv = FilterDataSet(objDs, "SUPERVISOR_NAME LIKE 'se_n'") where objDs is the data set should return "sean" but is not not fimilar with wildcards any ideas? Cheers
Hai,
objDv = FilterDataSet(objDs, "SUPERVISOR_NAME LIKE '%se_n%'")
use this '%' sign some times it works if the data contained in a word or spaces added to that data. underscore may not work in certain situations. asithangae