Query # sign in Access ODBC

[mmaki]

I'm trying to query the # sign from a recordset. For example I want to find all the records equal to # 31. I understand the # is a reserved symbol, and to use it in a query it should be bracketed [#]. I've tried several combinations of syntax but no luck. I can do it with an Access query, but when I copy the SQL to my FrontPage query it fails. Message returned was an error with my SQL statement. If I submit the same query without the [#] it will return the records for the number alone. Any ideas?

Thanks.