Formula to select records if the field contains a "Y"

[lindagoodwin]

I am using Crystal Reports 10.0

I have a field that contains the Patient Insurance ID.

INSURANCE.PATIENT_HEALTHCARE_COVERAGE_ID

The field should look similar to these:

897451234D5
145891177Y3
6549812677Y

I only need to pull the records with a "Y" in the last two digits. I have no idea how to do this. Any help you can give would be greatly appreciated.

Thanks

 

[Madawc]

Try something like

if Right({Yourfield},1) = "Y"
or Mid({Yourfield},10, 1) = "Y"

If the field lenght is variable, you could use Left(Right({Yourfield},2), 1) = "Y" for the second test.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[CR85user]

Or maybe:

right({your.field},2) like '*Y*'

Or if the text is not guaranteed to be uppercase then:

ucase(right({your.field},2)) like '*Y*'


'J

CR8.5 / CRXI - Discovering the impossible

 

[lindagoodwin]

The first formula suggested worked perfectly. Thank you very much. It makes my job much easier today!!!

 

[dgillz]

Instr({YourField},"Y")>0

The above will tell you if the string contains a Y anywhere within the string.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?