Problems With Wild Characters At Stored Procedure

Hello everyone,

 trying to use stored procedure for my datagrid.

in there i have the parameter that i would like to combine with wild character to retrieve some data..Does not work.

Please help to come up with right syntax...

here is the code:

SELECT First_Name, Last_Name, Address, City, Customer_ID, Company_Name, State, ZIP, Phone_Number_1, Phone_Number_2, Email

FROM v2_Customers

WHERE (City = @search_text) OR

(First_Name = @search_text) OR

(Last_Name LIKE '%'+@search_text) OR

(Address = @search_text)

 

where @search_text is the parameter,

 

thank you!