Overclock.net banner

1 - 1 of 1 Posts

·
Registered
Joined
·
85 Posts
Discussion Starter #1
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:
[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
[/CODE]

Can anyone help me out?
 
1 - 1 of 1 Posts
Top