How to use LIKE in a query

[ubusto]

Hi,
I am reading data from the Database using the provider "Provider=WCCOAoledb.WCCOAoledb;" using the query
"SELECT * FROM HISTVAL" and it works fine, but i need to do a more accuracy query with a query like this
"SELECT * FROM HISTVAL WHERE DPNAME LIKE '%DP1%'" the problem is that the LIKE'%%' is not working as expected

I would appreciate if someone could tell me how to use LIKE in this enviroment and the wildcards accepted for the WCCOAoledb

thx in advance

[Gertjan van Schijndel]

Did you also try it with a '*' instead of the '%'?

In the online help you can find examples under: System management -> Database -> OLE DB Provider -> Example queries

[ubusto]

Hi,
Finally it worked writing ... LIKE '*.NAME.*'
for example: SYSTEM_1:EXAMPLE.NAME.VALUE

[fmulder]

The portal has a section called 'Lab'. There, locate the X-File documents and look at the first document (X-File number 1).
The end of the document shows a range of sample queries

Good luck and share the fun

Frenk Mulder