Simple Formula Question.

[nervous2]

I am trying to make a small list to show all our formulas which end in a certain character.

Our product code is as follows.


EB-103-S
HS-155-G
PO-103-L
BW-245-L

Each character in the code has a specific representation therefore I would like to list all the codes that end in "L" I see the option as what I would like it to start with but I am not too sure how to set it up as to list with "ending with"

any info would be appreciated.

 

[MColeman]

{productcode} like '*L'

 

[Madawc]

Right({Product.code}, 1) = "L"
This will ignore LO-124-T, which MColeman's formula would have picked up. Check out the Left, Right and Mid commands, which are very useful.

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. I use Crystal 8.5.

Madawc Williams (East Anglia, UK)

 

[nervous2]

Both worked great! thanks for the help