need help on sql statement please i am useing visual basic

i am useing this statement
"select * from partfile where partname like '%KB001%' and flag=0"
 but the result shows
the part name   HKB001   only

is their any good statement to give me the best result

thanks alot
najixpAsked:
Who is Participating?
 
liviutudorCommented:
if you want to only match something like KB001***** then change the like pattern to this 'KB001%' (so you only match at the right)
0
 
hongjunCommented:
It should be correct.

What you expect to show but not displayed?
0
 
najixpAuthor Commented:
it should show me the record that contains the partname KB001 not HKB001

thanks
0
 
najixpAuthor Commented:
thank you thank you very very much
0
 
liviutudorCommented:
don't mention it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.