I want to search some data in a table that contains specific characters, for example :

in General Item Data, I want to search for Item Data that contains "EXP" characters.
The query results might be : "POT-0245-EXP", or "POT-7EXP-LCL" or "TEXP-0428-LCL"

Anybody knows what is the query/SQL syntax in BaaN to perform this searching ?

You can use the LIKE statement in the query:

<field> like ".*EXP.*"

The .* means any character, zero or more times.

Depending on the available keys and the number of records in the table you'd like to search you may have to choose the best path yourself. My solution is in the attached file. The document contains the source for two scripts one is a type 4 the other is a 3gl. In order to speed up the search (like didn't seem to work very well in our environment) I used the multiple server options - multithreading the tasks). This may not work on your system but it's worth a try - it really flies...
Note a custom table is required, if you need the definition gimme a shout.

Regards,
Rupert