Ends with Function???

[PQTIII]

Is there a function that allows you to pick data in fields where a string ends with a certain word? I have to filter out data that ends with the word "Backfill".

Cr9

data

5000 Backfill
4000 Backfill
5200 Bazza
TDW
TDN
Suz Backfill
3400 Bazza
SP Backfill

Thanks Paul

 

[kskid]

Try this

right(trimright({table.field}),8) = "Backfill"

The trimright function gets rid of any trailing blanks

-LW

 

[PQTIII]

LW

It worked great, thanks!