Endswith Function?

[MartUK]

I am using CR XI

I want to extract records where a field ends with RE from a string. It can be at any position in the field thats why I need ends with functionality rather than specific position

 

[dgillz]

This should work:

Right({YourField},2)="RE"

Although to play it safe, there may be trailing spaces, so I would trim the field first:

Right(Trim({YourField}),2)="RE"

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

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[lbass]

Try something like:

right({table.string},2) = "RE" or
{table.string} like "*RE *"

-LB