Selection criteria for crystal report

[Former Member]

I need to select jobs that have 'F' followed by a number or an 'A'. I can get the F by using instr({Job.Job},'F') to show if there is an F in the job. But I am getting stuck when trying to pull only jobs with an F followed by a number or an 'A'.

[Former Member]

Try

If isnumeric(Mid({{Job.Job,instr({Job.Job}, 'F')+1,1))

or Mid({Job.Job},instr({Job.Job}, 'F')+1,1) = 'A'

then 1 else 0

replace then 1 else 0 with your Condition

Ian

[Former Member]

You can replace 1 else 0 with true else false and it should work directly in your select filter.

Wrap whole condition to brackets to combine with other conditions

Ian