1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| CREATE TABLE T_DEGUEULASSE_DLG
(COLONNE1 INT,
COLONNE2 VARCHAR(16),
COLONNE3 VARCHAR(128))
INSERT INTO T_DEGUEULASSE_DLG VALUES (72, 'FRANCE', 'Paris-maison7-wx3-www.site1.com')
INSERT INTO T_DEGUEULASSE_DLG VALUES (121, 'FRANCE', 'Paris-maison7-wx3-www.site2.com')
INSERT INTO T_DEGUEULASSE_DLG VALUES (18, 'FRANCE', 'Lille-mairie-mx3-www.site1.com')
INSERT INTO T_DEGUEULASSE_DLG VALUES (123, 'FRANCE', 'Saint-germain en laye-mairie-mx3-www.site1.com')
-- Recherche de la 4e information :
SELECT COLONNE1, COLONNE2,
SUBSTRING(COLONNE3, CHARINDEX('-', COLONNE3) + 1, LEN(COLONNE3) - CHARINDEX('-', COLONNE3)) AS COLONNE3
FROM
(
SELECT COLONNE1, COLONNE2,
SUBSTRING(COLONNE3, CHARINDEX('-', COLONNE3) + 1, LEN(COLONNE3) - CHARINDEX('-', COLONNE3)) AS COLONNE3
FROM
(
SELECT COLONNE1, COLONNE2,
SUBSTRING(COLONNE3, CHARINDEX('-', COLONNE3) + 1, LEN(COLONNE3) - CHARINDEX('-', COLONNE3)) AS COLONNE3
FROM T_DEGUEULASSE_DLG
) T
) TT
COLONNE1 COLONNE2 COLONNE3
----------- ---------------- ----------------------
72 FRANCE www.site1.com
121 FRANCE www.site2.com
18 FRANCE www.site1.com
123 FRANCE mx3-www.site1.com |
Partager