Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 search function

Author  Topic 

php95saj
Starting Member

43 Posts

Posted - 2002-05-21 : 11:51:55
I am trying to build a dynamic search function. Allowing user to select which fields he/she wants to look into.

The user will have the choice of selecting from first name, last name, email ,address, company name, zip code, etc..

I am using the popular search stored procedure from sqlteam website.
What will be the syntax to build the search from the passed list of field names to be searched onto.

Thanks.



Sharjeel

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2002-05-21 : 19:49:20
quote:

I am using the popular search stored procedure from sqlteam website.



Must be very popular...mind posting it?

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"
Go to Top of Page
   

- Advertisement -