arows = ListsTBL.Select("col001 like '%caseIMDATA1%\" & BOID & ".tif'")

Ok the this is the dataset filter criteria it translates out to:


col001 like '%caseIMDATA1%\30301.tif' :::::::::: as the filter

In sql the equivalant

select * from lists where col001 like '%caseIMDATA1%\30301.tif'

works like a charm!

IN vb.net i get this error:

An unhandled exception of type 'System.Data.EvaluateException' occurred in system.data.dll

Additional information: Error in Like operator: the string pattern '%caseIMDATA1%\30301.tif' is invalid.


Please anyone that can privde any info help! My entire project has been leading up to the requirements of this filter to work, else i have a LOT of rewrite to do :/