formatting phone number

[rds747]

I have to format a phone number. This is what I have so far:

Select left(ltrim(CmPhone), 3) + '-' + right(rtrim(CmPhone), 7) as CmPhone From CusMast

How would I put a hypen between digit 6 and 7?

Thanks!

 

[SQLDenis]

One way

Select left(ltrim(CmPhone), 3) + '-' + substring(ltrim(CmPhone), 4,3)+ '-' + right(rtrim(CmPhone), 4) as CmPhone
From CusMast

test script

create table #testp(CmPhone varchar(49))
insert #testp values('1112221234')
Select left(ltrim(CmPhone), 3) + '-' + substring(ltrim(CmPhone), 4,3)+ '-' + right(rtrim(CmPhone), 4) as CmPhone 
From #testp

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[rds747]

Thanks Denis

 

[SQLDenis]

No problem

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/