Posted by anoosh on 07/19/07 20:57

hi all
I want to write a sotred procedure which has a parameter,called
@name.The SQL statement must return all rows where this parameter is a
subatring of a special column called FirstName.This procdeure do the
same ,but return all rows where @name is the exact matching.what
should I do?


/*
This procedure return the exact matching
*/
CREATE PROCEDURE substring
@name varchar(50)
AS
SELECT *
FROM table1
WHERE (table1.firstName LIKE @name);

[Back to original message]