LIKE clause with special characters

Hi All,

I'm having problems with LIKE clause that contain special characters.

I'm doing something like

SELECT * FROM Table WHERE FieldName LIKE '%10' & Chr(37) & '%'

But it doesnt seem to recognize the pattern as 10%. Instead it is returning all the hits for 10?

Help much appreciated

Sudha

[354 byte] By [sravikumar1] at [2007-9-26 4:40:37]