I am trying to write a stored procedure that searches for text and not sure how to put a wild card either side.

Can someone help please.

[
Code SQL:
ALTER PROCEDURE [wneedham].[adfero_article_search]
 
            @search_text               VARCHAR(255) = NULL
 
AS
 
BEGIN
 
 
            SELECT * FROM adfero_articles WHERE contents LIKE 
 
 
             '%@search_text%'
 
             ORDER BY created DESC
END