34,588
社区成员
发帖
与我相关
我的任务
分享
if object_id('tb') IS NOT NULL
DROP TABLE tb
GO
Create TABLE tb(cardnum varchar(18))
INSERT INTO tb
SELECT '000000000000000000' UNION ALL
SELECT ' ' UNION ALL
SELECT '400800400880080800'
SELECT * FROM tb
/*
cardnum
------------------
000000000000000000
400800400880080800
(3 行受影响)
*/
UPDATE tb SET cardnum =case when REPLACE(LTRIM(RTRIM(cardnum)),'0','')='' THEN NULL
else cardnum
END
/*
cardnum
------------------
NULL
NULL
400800400880080800
(3 行受影响)
*/
update
table
set
column =case when replace(column,0,'') is null then '' else column