[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

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
0
najixp
Asked:
najixp
  • 2
  • 2
1 Solution
 
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
 
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
 
najixpAuthor Commented:
thank you thank you very very much
0
 
liviutudorCommented:
don't mention it.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now