Yes, The LIKE operator in SQLECT supports "%" and "_" wlidcard characters. "%" means any set of characters, "_" - any one character. See BOL for details.
If the 'date' column is a character type than

SELECT * FROM CUSTOMER WHERE DATE LIKE '2/%/200_'

If your 'date' field is a datetime than you can use DATEPART() function.

SELECT * FROM CUSTOMER 
  WHERE DATEPART(year, [date]) >= 2000 
    AND DATEPART(mm, [date]) = 2

>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..