34,588
社区成员
发帖
与我相关
我的任务
分享
declare @sql nvarchar(2000)
select @sql=isnull(@sql+',','')+card from CardTable
select @sql
--把数据抽到一起
--观察对比一下
--分析什么在作怪
select card from CardTable where card like '%20080229490458002833%'
select card from CardTable where replace(replace(replace(ltrim(rtrim(card)),char(9),''),char(10),''),char(13),'')='20080229490458002833'
select card from CardTable where ltrim(rtrim(card))='20080229490458002833'