Access 97 Select * Where x LIKE "%nn%" not working

[yooper]

I'm using Access 97 to access our database, and everything is working fine except when we try to use a "LIKE" conditional. Does anyone out there have any suggestions as to why this wouldn't work? Here's the actual select statement:
SELECT * FROM [MainTbl] WHERE DiscNo LIKE "%603%"Thanks for any and all help you can offer!

Dave

[hspc]

Access uses * , ? instead of % , _
SELECT * FROM [MainTbl] WHERE DiscNo LIKE "*603*"

[yooper]

Thanks! I'll give that a try at work first thing tomorrow!

Dave