Wildcard not working in select expert (1 Viewer)

[PeterOC]

Hi,

Can anyone help with this:

I need to search for all records that have a {description} field that contains the word "Travel". Sounds easy? I thought so. I've reduced the search down to 1 record which I know contains "Travel" and the formula is:

{JobNumber} = "14248359" and
{Description} like "*Trav*"

but it returns no records. I've tried various permuations of wildcards but can't get it to work.

Thanks,

Peter

 

[PeterOC]

I figured it out. I didn't realise crystal was case sensitive. My record read "TRAVEL" and I was looking for "*Trav*"

Solution was to change the formula to:

{JobNumber} = "14248359" and
uppercase({Description}) like "*TRAV*"