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"