substring matching

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);

Re: substring matching

anoosh (paytam@gmail.com) writes:
> 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);

LIKE '%' + @name + '%'


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: substring matching

Based on you narrative, the query you need is:

SELECT *
FROM table1
WHERE @name LIKE '%'+table1.firstName+'%'

HTH,
Gert-Jan


anoosh wrote:
>
> 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);