Right now, I have a simple search that uses a StoredProcedure with a param varchar(300) to find Products. I pass in a user input string %string%, and it fetchs what comes up to a datagrid. Is there a better method? Maybe RegExp? I'm asking in regards to only SQL Server, unless you know there is just a better way that is SQL92 compliant or something.

Code:
CREATE ....
@SearchKey varchar(300)
AS
    SELECT * FROM Products WHERE ProductName Like @SearchKey
I know this should be in the DB forum but they never seem to answer me......