How To Use Wildcard Characters in Query Search

[Keats713]

I have a table full of thousands of results for the past few years. I created a query that requires the input of a Product ID (4-6 numbers) and a Code Date (formatted ###-#). The code date is in julian date format, so the code date corresponding to January 1st, 2016 would be 001-6.

I need to query the table and pull all results from 2016 for any product.
Product ID - Anything
Code Date - (###-6) <-- The first 3 digits can be any number, but the number after the hyphen has to be 6.



I can't seem to figure out how to use the wildcard characters correctly in the query inputs to pull the data that I need. And I do not have time to go through all of the records to find all code dates ending in 6. Can someone help me figure out how to pull what I need?

[ranman256]

Select * from table Where [codeDate] like "*-6"

[CJ_London]

Appreciate you may not have any at the moment, but assuming your app has some longevity - what happens with dates in 2006 or 2026?