SQLQueries for Service Layer how to use LIKE search with parameters

[former_member733135]

How could I do a search by text using like '% searching%' with parameters

{ "SqlCode": "GBSql003", "SqlName": "ItemsWhsCodePrList", "SqlText": "SELECT T0.[ItemCode], T0.[ItemName], T0.[FrgnName], T1.[OnHand], T1.[IsCommited], T1.[OnOrder], T1.[WhsCode], T2.[PriceList], T2.[Price], T2.[Currency] FROM [OITM] T0 INNER JOIN [OITW] T1 ON T0.[ItemCode] = T1.[ItemCode] INNER JOIN ITM1 T2 ON T0.[ItemCode] = T2.[ItemCode] where T0.[ItemName] LIKE :ItemName and T1.[WhsCode] = :WhsCode and T2.[PriceList]= :PriceList GROUP BY T0.[ItemCode], T0.[ItemName], T0.[FrgnName], T1.[OnHand], T1.[IsCommited], T1.[OnOrder], T1.[WhsCode], T2.[PriceList], T2.[Price], T2.[Currency]" }

http://server:50001/b1s/v1/SQLQueries('GBSql002')/List { "ParamList":"ItemName='' %?HERE?% ''&WhsCode='BAQ'⪻iceList=1" }