<font face='Verdana'>I would like to search for a variable/word not only in one collumn (of a table), but for example in 2 collumns at one time.

I tried this, but...:
SELECT *
FROM Autos
WHERE Auto1 = 'MMColParam' AND Auto2 = 'MMColParam'

Any ideas?</font id='Verdana'>

Hmmm it has to be somthing like this i think

SELECT*
From Autos
WHERE Collumname LIKE '%varSearch%' OR collumname LIKE '%varSearch'% ....

Variabels
Name: varSearch
Default Value:0123456
Run-Time Value: Request("name of the field who passes the variable/word"

I think this should do it
ps: Repeat : OR collumname LIKE '%varSearch'% as much as you want

Greet DarKPsyChO

The Power Is In The Code

whoops made a typing mistake
it is '%varSearch%' in stead of '%varSearch'%

<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>
Greetd DarKPsyChO

The Power Is In The Code