Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

search with sql vb6

Comment:

Please can someone help me with an sql search query, i want to be able to find a record but typing letter for letter, like winamps search feature for songs, eg- i type in "a" and it finds all records starting with "a" and so on, please help, thanks, Anthony

Name: StuartS
Date: June 20, 2005 at 06:03:15 Pacific

Reply:

Use the LIKE keyword. SELECT * FROM Database WHERE Surname LIKE A* Lookup LIKE in the help files. There are lots of information on different parameters you can use. Stuart

0

Help on including pthread...

.NET combo boxes

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: hi, Working on VB with sql7.0, on WinME. While trying to connect to sql, it's not connecting. Neither there is any error message. Some one please show me a way, AS HOW TO CONNECT VB6 WITH SQL DATABASE...

Summary: Hi, I'm writing a tech call log program. It logs phone calls for tech support. Database is access 2000, using DAO 3.6 My problem is I don't know how to look up previous records between 2 dates, with...

Summary: I am kinda confused by your post. Do you want to know what language to use to write a program to create tables and retreive data from those SQL db tables, or you do want to know what program you can ...