Query for last character 2

[tlove161]

I have an EVENT_ID field which has a mix of letters and numbers, (i.e., 04302004SPittsburX01). I need a select query that returns all EVENT_IDs which end in X02 or higher (i.e., 05282004SPittsburX02). What do I need to put in the criteria portion of the query design window under EVENT_ID?

Thank you.

 

[SkipVought]

tl,

[tt]
Where Right(EVENT_ID,3)>="X02"
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[PHV]

end in X02 or higher
WHERE Right(EVENT_ID, 3) >= "X02"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244