Vote count: 0
I am Not Sure if this can be done by sql.may someone please help me if possible with sql. i have a table with data looks like given below.
DECLARE @MYTABLE TABLE
(
ColumnA VARCHAR (50)
)
INSERT @MYTABLE
SELECT '01268 591558 * 3 Marina' UNION ALL
SELECT '01322 421980 JULIE A/P' UNION ALL
SELECT '01296620096 BR TAKES CARD EOM' UNION ALL
SELECT '07547 740863/07986 019852' UNION ALL
SELECT '07754553528 - TIM' UNION ALL
SELECT '07732418595 sam' UNION ALL
SELECT '01793 425574- Charlotte' UNION ALL
SELECT '01268 591558 * 3 Marina' UNION ALL
SELECT '07967 967404 CELIA' UNION ALL
SELECT '0208 361 1213 / 1433 /8899 ' UNION ALL
SELECT '0208 361 1213 / 1433 ' UNION ALL
SELECT '0208 361 1213 / 1433' UNION ALL
SELECT '01206 578671 / 564272' UNION ALL
SELECT '01206735561/07748116152' UNION ALL
SELECT '0208 361 1213 / 1433 ' UNION ALL
SELECT '01234 754047 SUE' UNION ALL
SELECT '01206735561/07748116152/0156589'
and i am expecting output like
May someone please help me on this.
Thanks
asked 28 secs ago
Critical Regex Implementation in sql
Aucun commentaire:
Enregistrer un commentaire