Is it possible to execute a query using PI-OLEDB restricting the results to only those where the 'Annotations' field matches a particular pattern? For my data, I have a scale factor, an offset factor, and an optional QC flag for each observation of the form:
0.33,0.76,12222200000000
What I want to accomplish is to find the last observation that has a QC flag assigned to it (so the QC can start from that point). I am using the query:
Code:select top 1 time from picomp2 where tag = 'poplar_greenwood_1_2151_2.0_P1_Avg' and annotations like '*,*,*' order by time desc
However, when I execute the query, I receive the following error message:
Code:
??? Invoke Error, Dispatch Exception:
Source: PIOLEDB
Description: Overload resolution failed for (LIKE) argument(s).
Thanks in advance for any help.
