有关sql多个字段拼接查询的问题

[cf_nxcxy]

表tb
三个字段A，B ，C
字段A是字符串nvarchar类型，字段B和字段C是int类型
现在要做的是把这个三个字段拼接起来做查询
select A+B+C from tb where A+B+C like '参数'

求大神帮忙写一下
注：B和C两个字段有空值

[md5e]

select (A+cast(B as nvarchar(10))+cast(C as nvarchar(10))) as [D] from tb where (A+cast(B as nvarchar(10))+cast(C as nvarchar(10))) like '参数'

[md5e]

select (A+isnull((cast(B as nvarchar(10)),'')+isnull(cast(C as nvarchar(10)),'')) as [D] from tb where (A+isnull(cast(B as nvarchar(10)),'')+isnull(cast(C as nvarchar(10)),''))