sql server:对自定义变量进行模糊查询

DECLARE @Code NVARCHAR(50);  
SET @Code =( SELECT MAX(  CONVERT(INT, Code) ) CODE FROM Base_Commodity
WHERE OwnerCode='3502100081' );   -- 自定义变量，并赋值

DECLARE @CNum NVARCHAR(50);  
SET @CNum =
(SELECT count(1)+1 AS COUNT FROM Base_Sku
WHERE OwnerCode='3502100081'
and ChannelSku like '%'+CAST(@Code AS NVARCHAR(36))+'%'); -- 转化为str,并进行模糊查询