回答編集履歴
1
文法の修正
test
CHANGED
@@ -1,4 +1,4 @@
|
|
1
|
-
SELECT
|
1
|
+
SELECT CASE WHEN LENGTH( tel )<11 THEN LEFT(tel,2) ELSE LEFT(tel,3) END tel1, SUBSTRING( tel, -8, 4 ) tel2, RIGHT( tel, 4 ) tel3 FROM table
|
2
2
|
|
3
3
|
|
4
4
|
|