Critical Regex Implementation in sql

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

Rohini Mathur

Let's block ads! (Why?)

Critical Regex Implementation in sql