I have finally solved the problem
Here is the solution
Select command shall look like this
"Select * from tblEmolyee " & " where lastname like '" & searchname & "%' "
I am just a beginner so the following statemnts shall be accepted with a grain of salt by other my kind of programmers.
I invite and would greatly appreciate if GURU'S make a statement so other poeple with my kind of limitations dont get a erroneous suggestion from me
The problem I was having with was placement of % (wild character) and spaces.
spaces in the statement text are accepted by VB
.net as actual spaces in commandtext
therefore program was reading my statement as "SearchName(space)then %
or it was not finding a match