R

Hello,

I want to make a stored procedure to search row :

How can I do to search only on begin of field ?

Thanks

Don′t know if I understand you right, but that should be something like that:

CREATE Table SomeTable
(
SomeColumn VARCHAR(200)
)

GO

CREATE PROCEDURE SomeProcedure
(
@.SomeSearchValue VARCHAR(200)
)
AS
SELECT SomeColumn FROM SomeTable
WHERE SomeColumn LIKE @.SomeSearchValue + '%'

GO

INSERT INTO SomeTable VALUES ('SomeValue')

EXEC SomeProcedure 'Value'

--(0 row(s) affected)

EXEC SomeProcedure 'Some'

--SomeValue

--(1 row(s) affected)

--Clean the House

DROP PROCEDURE SomeProcedure
GO
DROP Table SomeTable

HTH, Jens Suessmeyer.