Is there a way to use wildcard characters in an sql statement.

ie: SELECT * FROM CUSTOMER WHERE DATE LIKE '2/**/200*'

I want the ** to be wildcard characters..