Sql Search query

[bluetiger]

hi i am trying to search multipul fields in my database i have tried this code

[code]
SELECT *
FROM Profile
WHERE Location1 = 'colname'
OR Location2 = 'colname'
OR Location3 = 'colname';

 

but its giving me this error

Missing type for variable:colname

 

Any suggestions on this.

 

thanks[/code]

[christofurr]

So you have a table named Profile which consists, at least, of three columns named Location1, Location2, and Location3, and you're trying to search each of those columns for the string "colname"?

[bluetiger]

Yes instead of doing loads of individual querys i wanted to try and use just the one as there is going to be more than just for the location.

[MemphiS]

Could you post a few more lines of code before and after... Also colname? i would assume is a variable?