Stored Proceedure

I was using a proceedure i created in code but because of the way i am using it i decided that a stored proceedure will work better





i have a few add proceedures that work for insert and update but when i tried a select command, no matter what the data entered it returns the first record in the table when I fill the dataset does any one have a clue as to why it would do this


is there something you have to return through the stored proceedure


like you do when you use @@Identity





this is what i currently have,





CREATE PROCEDURE Location_Select








@p1 char(15)


AS


SELECT LocationID FROM t_Location WHERE (LocationPhone = @p1)


go





do i need this? and if so what can i return i tried LocationID and it yelled at me saying that is an invalid column name








CREATE PROCEDURE Location_Select








@p1 char(15),


@retval int output





AS


SELECT LocationID FROM t_Location WHERE (LocationPhone = @p1)





SET @retval =LocationID


GO











thankyou