Exact match

[lebronletchev]

Hi,

I am trying create a simple "Select" for exact match. I am trying:

'%" & strKeyword & "%' - Find all matches! Don´t work for me!

'%" strKeyword "%'

'" & strKeyword & "'

'" strKeyword "'

'strKeyword'

All above examples not works for find exact matches!

Could you help me?

Thanks

Lebron

[nbcrockett]

Your select statement should look something like this.

"SELECT * FROM YourTable WHERE YourField LIKE '%" & strKeyword & "%'"

[lebronletchev]

No. In this way It find all words that contains, for example "the", such as "whether".

From other hand if I use
"SELECT * FROM YourTable WHERE YourField = '%" & strKeyword & "%'"

it display nothing!

Thanks

lebron

[nbcrockett]

I don't think you can use the = sign and wildcards together. However you could try this.

SELECT * FROM YourTable WHERE YourField LIKE '% " & strKeyword & " %'"

This I believe would keep you from finding "whether". However the down side of this is that if your data has anything but spaces before or after your keyword than it won't return that record (i.e. the,).

Here's another post where me and some other people discussed a similar problem.
http://www.webdeveloper.com/forum/sh...d.php?t=152839