Hi all,

i want to query a table (ttadv200), with the following query:

$BSE/bin/qptool6.1 -c 000 -o /tmp/query997.out -q "select cpac,cmod,cses,vers,rele,cust from ttadv200" > /tmp/logquery.out

This works fine, but i want to query all rows where the "cust" field has "pa02" in it. The "cust" field is a String.

so my question is:

Which sql-statement must I use?

I tried "%pa02%" or like "%pa02%" .......

Thanks in advance.

Greetings

HM

almost ...

use where cust = "pa02" or
use where like ".*pa02.*"

Hi,

thank you very much.

That was the solution for my problem.

Greetings HM