Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
data_analysis:work:corp_code [2020/03/05 00:50] – ↷ Links adapted because of a move operation 164.124.106.136 | data_analysis:work:corp_code [2025/07/07 14:12] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 30: | Line 30: | ||
Reg2 | Reg2 | ||
} | } | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== SQL ===== | ||
+ | <code sql> | ||
+ | case | ||
+ | when length([사업자번호]) <> 10 then ' | ||
+ | when [사업자번호] is null then ' | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | when substr([사업자번호], | ||
+ | else ' | ||
+ | end | ||
</ | </ | ||