need Exact match syntax for Search algo

[WozFromOz]

Using Access 97 db on IIS5

I am modifying my search algo to find exact string matches using "like '%[!a-z][search term[!a-z]%'" which is pretty clumsy and also doesn't pick up the search term if it is at the beginning of a sentence.

Can anyone help me with the syntax here, I am sure there must be some operator within SQL as there is in FMP but I cannot find it.

Thanks all

Onya
WozfromOz

 

[link9]

I can't help much with this because I don't use Access too much, but I bet if you posted this thread in any of the Access forums, those folks could fix you right on up. They have some good people over there.

good luck!
Paul Prewett

 

[WozFromOz]

Sorry, not enough information in my question.

I am using ASP to query access on IIs5 so my question goes to the asp syntax. But then I guess it also relate to SQL.

Thanks for the suggestion, I'll try in the access and sql forums.

Onya
WozFromOz

 

[TimLarkin]

I not sure why you're using the not a-z part, but aside from that, it really isn't as clumsy as it seems. However, to make it work the way you want:
"MyField like '%[!a-z][search term[!a-z]%' OR MyField like '[search term[!a-z]%'"

 

[phuctran]

I think NOT is ^ not !.