Use wildcard search
CREATE PROC [dbo].[StoredProcedureName]
(
@Parametername nvarchar(50)
)
AS
SELECT ColumnName FROM TableName
WHERE ColumnName LIKE '%' + @Parametername
'%' before you criateria mean anything that starts with your criteria, at the end meant end with. Before and after, will bring results containing your given value...