database - Format Phone Number SQL Server -

database - Format Phone Number SQL Server -

i working on stored procedure in part, pulls phone numbers database. in cases, number may in wrong format. right format is: +714xxxxxxx, there cases number appears as, e.g: 142877261 or 7147267261. there cases number appears say, ++1749186372

how can forcefulness number append +714 start while keeping rest of number intact?

any help much appreciated.

you can take 7 right digits , unconditionnaly preprending +714

'+714' + right(phonenumber, 7)

sql database sql-server-2008 stored-procedures