Hello friends,

I'm sure this has been asked before, but I can't make this query work for me as I am new to crystal.

I'm using Crystal Reports 10.

I need to search an Account Code string and find "35" at the 5th and 6th positions in the string.

The account code looks like this: PRCP353F5720-06101

The number "35" will ALWAYS be at the 5th and 6th position in this field.

I know the below is not correct, but I need to query something like:

Select *
From table
Where Account_Code Left("35",5)

I also need to run the above in SQL to test my results. I can't make this work in SQL and can't seem to get a formula to work in Crystal in record selection.

Can somebody please help me with the correct syntax for both of those?