Zach,
Helped heaps - working great now.
Thanks so much,
Matt.
MaliciousMatt
Last Activity: Mar 9 '09, 12:31 PM
Joined: Mar 6 '09
Location:
-
Hi Zach,
I think your onto something there - sounds right.
I'll give it a shot tomorrow and tell you how I go.
Thanks heaps - it's amazing how much I have just learnt if that's all it was.
Cheers,
Matt.Leave a comment:
-
I just realised this is in the MySQL threads...oops.
It's MS SQL.Leave a comment:
-
LIKE Condition while using parameters
Hi All,
I'm trying to create a search stored procedure within MSSQL.
I've come up with the following:
I've tested this a few times on the test data I have in the database but it does not seem to be working...Code:ALTER PROCEDURE [dbo].[usp_Search] @SearchText nchar(15) AS BEGIN SELECT * FROM dbo.Person WHERE FirstName LIKE '%'+@SearchText+'%' END
No activity results to display
Leave a comment: