22,209
社区成员
发帖
与我相关
我的任务
分享
select * from a,b
where a.id = b.id+'%'
select * from a,b
where a.id like b.id+'%'
select * from a,b
where a.id like cast(b.id as varchar(100))+'%'
select * from a,b
where a.id = b.id+'%'
select * from a,b
where CHARINDEX(a.id, b.id) = 1