34,590
社区成员
发帖
与我相关
我的任务
分享
update tb set sfzhm = upper(sfzhm) where sfzhm like '%x'
DECLARE @time VARCHAR(20)
SET @time = '35082302200700080x'
SELECT REPLACE(@time,'x','X')
UPDATE tb SET sfzhm = REPLACE(sfzhm,'x','X')
update table_name
set sfzhm=replace(sfzhm,'x','X')