Compare with LIKE?

Soloper

Hi experts;

Is it possible to compare two text value with LIKE? (in c/al)


Something like the code below :

If tableA.FieldA Like *ABCD* Then
..
..

This doesnt work.

Any suggeestion?

matteo_montanari

Soloper wrote:

Hi experts;

Is it possible to compare two text value with LIKE? (in c/al)


Something like the code below :

If tableA.FieldA Like *ABCD* Then
..
..

This doesnt work.

Any suggeestion?

Hi

You can use "STRPOS" function

IF STRPOS(tableA.FieldA, 'ABCD') <> 0 THEN
...

Bye

Matteo

Soloper

Works fine.

Grazie Matteo.