我感兴趣的是生成一个脚本来识别“邮政编码”列下的记录,该列之间有双空格,而不是单个空格。
表名: Tabu2
Cit_ID DOB Status Postcode
1 12/84 S KT1 3GP
2 11/81 S KT2 2PI
3 13/80 M KT1 2PP
4 15/78 M KT3 2ON
5 13/67 M KT5 4II非常感谢
发布于 2016-11-10 15:52:41
Select *
From Tabu2
Where Postcode like '% %'或
Select *
From Tabu2
Where CharIndex(' ',Postcode)>0修复
Update Tabu2 set Postcode=Replace(Postcode,' ',' ')
Where CharIndex(' ',Postcode)>0发布于 2016-11-10 15:52:01
select * from your_table
where postcode like '% %'https://stackoverflow.com/questions/40531684
复制相似问题