Use CONVERT() function for
ID_Product
column like :
Select ID_Product as 'Drug ID'
,Label_Product as 'Drug Name'
,Expair_Date as ' Expair Date '
,Qte_In_Stock as 'Quantity'
, Price as 'price'
,DESCRIPTION_CAT as 'Company '
from Products
inner join CATEGORIES
on CATEGORIES.ID_CAT =PRODUCTS.ID_CAT
where CONVERT(varchar,ID_Product)+LABEL_PRODUCT+CONVERT(varchar,Expair_Date)+Qte_In_Stock
+CONVERT(varchar,Price)+CONVERT(nvarchar,DESCRIPTION_CAT)
like '%' + @Criterion + '%'