[RESOLVED] Please Help - VB 6.0 and Select command

I am using vb 6.0 and i am using this command

"SELECT * FROM personalinfo WHERE personalinfo.empid = " &
"'" & txtemid.txt & "'"

my problem is i would like to search also the position of a particular person, but something list a comparison LIKE command is use to compare.. but i would like to compare a word to a field for intance....

Structural Welder
Pipe Welder
Welder Supervisor
Welder Inspector

my keyword is "welder"

The above is sample only, when i type the word.... "welder" the query will display the above position even the word is in the start middle or last.
Is it possible? please help anyone... plz thank you.

What should i place instead of "LIKE"

Which database are you using?

For access the query would look like this

PHP Code:

---

"SELECT * FROM personalinfo WHERE personalinfo.empid like ('*" & txtemid.txt & "*')" 


---

And for SQL Server it will look like this

PHP Code:

---

"SELECT * FROM personalinfo WHERE personalinfo.empid like ('%" & txtemid.txt & "%')" 


---

i am using access database 2000 version

thanks friend.... its working... thanks for the information..