Results 1 to 2 of 2
Thread: Problem with stored procedure
Apr 29, 2005, 02:25 #1
Problem with stored procedure
I am using a simple stored procedure that just searches for the cities whos name starts with the keyword enterd. But the below code dosnt seems to work. any ideas.
I am using SQL Server 2000
CREATE PROCEDURE va_search_location @keyword varchar(50) AS Select * from tblcities where CityName like '@keyword%' GO
Apr 29, 2005, 02:57 #2
problem solved..missed on concatenating part
Select * from tblcities where CityName like @keyword+'%'