Posts by Marcel Leandro • 11 points

• 1

  votes

  5

  answers

  6773

  views

  A: Separate ddd from phone with SQL statement

  select left( convert(bigint,replace( replace([Telefone],' ',''),'NULL','')),2) as DDD, Substring( convert(varchar(255),convert(bigint,replace( replace([Telefone],' ',''),'NULL',''))),3,11)…

  sql sql-server dql ddl

  answered 8 years, 11 months ago Marcel Leandro 11