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)  how to implement this.

Author  Topic  ajay Starting Member 34 Posts Posted - 2001-06-27 : 09:22:16 Dear gurus, I dunno how to write this procedure for search. Here is something, I'd beed workin but gettin nowhere. CREATE PROCEDURE search ( @query varchar(20), 'searched word @area varchar(20) area is the current region from where the search is activated ) as select details from case when @area="lifystye" then "content"(these are table name) when @area="business" then "finance" (table name) else "general" end where header like %query% ajay