I'm trying to create a search stored procedure for a web application and am having problems getting it to return any results.
Code:
[/CODE]
Can anyone help me out?
Code:
Code:
[CODE]
ALTER PROCEDURE usp_Search
@SearchText nchar(10)
AS
BEGIN
SELECT dbo.Person.PersonID, dbo.Person.FirstName, dbo.Person.LastName, dbo.Person.ExtID, dbo.Person.Mobile, dbo.Position.Position_Name,
dbo.Section.Section_Name, dbo.Division.Division_Name
FROM dbo.Person INNER JOIN
dbo.Extension ON dbo.Person.ExtID = dbo.Extension.ExtID INNER JOIN
dbo.Position ON dbo.Person.PositionID = dbo.Position.Position_ID INNER JOIN
dbo.Section ON dbo.Person.SectionID = dbo.Section.Section_ID INNER JOIN
dbo.Division ON dbo.Section.Division_ID = dbo.Division.Division_ID
WHERE Person.FirstName LIKE '%' + @SearchText + '%'
END
Can anyone help me out?