Passing parameters with like

[SomeoneHere]

I was wondering I am able to pass a parameter but I want it to be like a string search. It is a persons name so if I wrote in Dan I want to be able for it to find Daniel. Thanks for any help.

[Phil Weber]

What kind of database? In SQL Server, you may either pass 'Dan%' as the parameter, or add the wildcard character within the stored procedure, e.g.:

SELECT * FROM TableName
WHERE Column LIKE (@param + '%')