SQL query: how to use "like" in "where" clause?

[ngong]

I tried like

select * from t_xref where Description like "%stereo1%stereo2%"

without success. I could not find any "like" example on Geert Belekens website or in the book of Thomas Kilian.

[ngong]

Found the answer:

as opposed to the link http://www.1keydata.com/sql/sql-commands.html found in the book of Thomas Kilian, it is "*" to be used, not "%".

[Geert Bellekens]

In EA you can use #WC# which will be translated to the correct wildcard by EA (* for .eap(x) files, and % for anything else)

Geert

[qwerty]

As Geert said. Mickeysoft has (like always) its own way to interpret a standard. That's the Mickeysoft Standard. Hence MS.

q.