SQL截取字符串

发布网友发布时间：2022-04-10 02:45

共2个回答

热心网友时间：2022-04-10 04:15

select WBOOK_NO =
case when WBOOK_NO like '%H%' and WBOOK_NO not like '%HW%' then SUBSTRING(WBOOK_NO,7,9)
when WBOOK_NO like 'H%' and then SUBSTRING(WBOOK_NO,8,9) end,
WBOOK_NO
from EMS_PDE_HEAD WHERE WBOOK_NO='H3001720130823003698' OR WBOOK_NO='HW300172012048035872'

LIKE 'H%'时再and NOT LIKE 'HW%'就好啦

热心网友时间：2022-04-10 05:33

select WBOOK_NO = case when WBOOK_NO like '%H%' then SUBSTRING(WBOOK_NO,7,9)
when WBOOK_NO like 'W%'then SUBSTRING(WBOOK_NO,8,9) else WBOOK_no end,--注意else语句
WBOOK_NO
from EMS_PDE_HEAD WHERE WBOOK_NO='H3001720130823003698' OR WBOOK_NO='HW300172012048035872'
or WBOOK_NO='201001780'

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com