4

I would like to get an object from t_object if its keyword contains word "Test" . Even if has "Testing" or "Tested" i need to get that data rom row .

In sql we can use LIKE keyword. But how to use it inside EA SQL Scratch Pad ..?

SELECT * FROM t_object where t_object.PDATA5 like '%Test%'

The above is not working within EA.

Dah Sra
  • 4,107
  • 3
  • 30
  • 69

1 Answers1

5

Depends on the RDBMS. If you use EAP the wild card is *. Most others use %. But Mickeysoft always implements its own flavors.

(See also chap. 13 of my Inside book.)

qwerty_so
  • 35,448
  • 8
  • 62
  • 86