View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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?