Creating a search procedure

Question

Creating a search procedure

Sherif Maamoun

Ten Centuries

Points: 1254
More actions
June 25, 2005 at 12:00 am

#167307

This must be a simple task. I need to create a stored procedure that will prompt the user to enter the first four letters of a name to return all customers with the letters entered

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Kathi Kellenberger SSChampion Points: 11811 More actions · Answer 1

Your program (webpage, Visual Basic or whatever) should prompt the user. Then your program will call the stored procedure with the the 4 letters as a parameter.

So you could have a stored proc something like this:

create proc usp_GetCustomers @Name varchar(4) as

set @Name = @Name + '%' -- add the wildcard

select Name from customers where Name like @Name

return 0

Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor

sajjadtx Valued Member Points: 52 More actions · Answer 2

don't we need close the wildcard '%'?

SQL Help Blog

sushila SSC-Dedicated Points: 35293 More actions · Answer 3

Kathi HAS closed the single string quote!

**ASCII stupid question, get a stupid ANSI !!!**

Creating a search procedure

Cookies on SQLServerCentral