Using Regular Expression $ in Access Queries

[rkdiekhoff]

Hi,



I'm trying to write a query in Access, which will select records where " IU" appears at the end of a text field. I've been trying to do this using a regular expression (" IU$") in the query's criteria, but can't get the results I'm looking for when the query hits up against test data containing instances as described above. I've also tried escaping out the $ and using the criteria as part of a LIKE statement, but it still does not work.

Is there a way to get this to work to in Access?

Here is basically the different things I've tried:

SELECT * FROM Test_Table WHERE StringField = ' IU$'
SELECT * FROM Test_Table WHERE StringField = ' IU\$'
SELECT * FROM Test_Table WHERE StringField LIKE '* IU\$'
SELECT * FROM Test_Table WHERE StringField LIKE '* IU$'
SELECT * FROM Test_Table WHERE StringField LIKE '* IU[$]'


Thanks,
rkdiekhoff

[RuralGuy]

Have you tried just using Right([YourField],2) = "IU"