Excluding numeric values in Query Filter
Try putting a like clause into the SQL like this
WHERE (Submissions.Task_ID Like '[0-9]+')
the square brack will says to take any characters 0 through 9 and the plus
say to do it infinite number of times
Submission is a table in one of my database and Task_ID is a column in the
table.
"Staten42" wrote:
I am pulling data from an ODBC connection, and need to filter results based
on a specific field. This particular field includes both alpha and numeric
values and I only want it to pull in one or the other. Any thoughts?
|