Shulou(Shulou.com)06/01 Report--

Ex.: there is a need to replace date 20170599 in a batch of order numbers with a new date 20180699

Before modification:

Select * from ICStockBill where FBillNo like 'WHFC201705%' order by FBillNo

Results:

FInterID FDate FBillNo

209234 2017-04-30 00 WHFC201705990001 00.000 WHFC201705990001

209235 2017-04-30 00 WHFC201705990002 00.000 WHFC201705990002

209236 2017-04-30 00 WHFC201705990003 00.000 WHFC201705990003

209237 2017-04-30 00 WHFC201705990004 00.000 WHFC201705990004

.

209239 2017-04-30 00 WHFC2017059900999 00.000 WHFC2017059900999

After modification

Use the replace function:

Format: repalce (field name, value to replace, new value after replacement)

If you replace a specific value, you can replace the field with the corresponding value, or specify it by condition.

Update ICStockBill set FBillNo=REPLACE (fbillno,'20170508','20180510') where FBillNo between 'WHFC201705080001' and' WHFC201705089999'

FInterID FDate FBillNo

209234 2017-04-30 00 WHFC201806990001 00.000 WHFC201806990001

209235 2017-04-30 00 WHFC201806990002 00.000 WHFC201806990002

209236 2017-04-30 00 WHFC201806990003 00.000 WHFC201806990003

209237 2017-04-30 00 WHFC201806990004 00.000 WHFC201806990004

.

209239 2017-04-30 00 WHFC201806990999 00.000 WHFC201806990999

In order to achieve this function, Baidu also did not take detours, specially left this article, only for the record, hoping to help people in need.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.