Hi,

I am currently doing a search engine for my project. The problem is if i have a record called "Hello World" in the database but when i search and type this "World Hello", no records will be found.

My sql statement is this "Select * from table where columnNA like % variable name %".
I would like to know is there any method that can solve my problem?

Snowydust

__________________
Snowydust

hi there...

you need to add some * and ? to your matching string.. you will never find a "reversed" string that way.. world hello is not like hello world..
you can find your record using *world or hello* or he*ld.. that way you will find it.. but adding * all over your string will not do the trick...

HTH

Gonzalo

Hi,

hmm, what i actually need is the sql statement, i don't think that sql statement support a * right? It seems that * is the same as % only that * works in dos. So can you give me a sample of the sql statement which may solve my problem?

Snowydust

yes it can.. try something like

Select * from table where columnNA like 'hellow*' and you will receive it...

HTH

Gonzalo

hi,

The only method which i try successfully is using the contains. Select * from tbl where contains(columnNA, 'variable'). I am using ms sql right now therefore i think that it only accepts % not *.

Snowydust

% is the same for *.. you use % in standard SQL and * in access.. my fault! :)



HTH

Gonzalo

'try this
'---------------------------------

"SELECT * FROM table WHERE columnNA LIKE'%" & Text1.Text & "%'"

happy coding

:)