PorterConsultingLLC
asked on
In Crystal Reports XI, How do I Select records from a field by the second character in that field?
In a report I am writing, I need to pull only the records that have a zero or a "C" as the second character in a specific field. Any suggestions? I was hoping a SELECT CASE (MID {FIELD1}, 2, 1) = 0) or SELECT CASE (MID {FIELD1}, 2, 1) = "C") would work, but I'm not doing something right.
Oops, missing left paren:
MID ({FIELD1}, 2, 1) = "0"
MID ({FIELD1}, 2, 1) = "0"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm not sure how to do this. In the Report/Select Expert, is there a way to tuck this in? I am NOT working with a SQL database, but a legacy flatfile db for which I link the tables in CR. This means I cannot do a view in SQL that would allow the select to happen before it gets to CR.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you all, VERY MUCH! It worked and I can move onto the myriad of other reports waiting for me!
BLESS YOU!
BLESS YOU!
MID {FIELD1}, 2, 1) = "0"
The zero is a character