I have lab values that are stored as text but look like numbers. I want to find all lab values less than 5, but I'm getting "10" etc. because it's text.

How can I make my query think the text are numbers so the query will work correctly. I'm connected via an ODBC connection so I can't change the actual table structure.

Thanks,
Pam

Search help for the Val() function.

Thank You!!! That did the trick.

Pam