Using '%' comparison in Crystal

[tomadobro]

Does anyone know how to use the '%' in Crystal Reports?

In SQL you can use this to search for a particular description through a field. An example would be;

SELECT ITEM
FROM INVENTORY
WHERE ITEM LIKE '%BEARING%';

This query would than find any items with the word 'BEARING' in them and display them.

Any help would be much appreciated! Thank you!

 

[Naith]

In Crystal, '?' wildcards one character, while '*' wildcards in the same way as Oracle SQLs '%'.

i.e.

SELECT ITEM
FROM INVENTORY
WHERE ITEM LIKE '*BEA?ING*';

returns anything with "BEATING" or "BEARING" in the string.

Naith