Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search Query Help

Status
Not open for further replies.
MayoorPatel

MayoorPatel

Programmer
Apr 10, 2006
35
GB
Hi there I have several fields on which a user can search on. I have set up my webform as you can see from this screenshot.


I would like to write a SQL query where by if anyone types any combination of entries into the fields the query will retun all matching records. Can anyone help....?
 
Sort by date Sort by votes
try a search on these topics:

1. EXEC Stmt - Dynamic SQL
2. sp_executesql


they might be the thing that you are looking for...

Known is handfull, Unknown is worldfull
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

f0rg3tfu1
  • Locked
  • Question
PLSQL Package Help
Replies
0
Views
408
f0rg3tfu1
f0rg3tfu1
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
947
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
467
Andrzejek
Andrzejek
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
336
Chris Miller
Chris Miller
bmacbmac
  • Locked
  • Question
Help searching within this Json file
Replies
0
Views
131
bmacbmac
bmacbmac

Part and Inventory Search

Sponsor

Back
Top