Phone number formatting

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

Possibly the easiest way would be

select convert(bigint,+9966557785.0000000000000000)

Depends on what you want to do with the number after this really though.

Clear Sky SQL
My Blog[/url]

Sirish-791018 SSChasing Mays Points: 644 More actions · Answer 2

SELECT SUBSTRING(phonenumber,1,charindex('.',phoneNumber)-1) from table

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

Sirish likely has the best answer for fixing currently incorrect data, the real issue is to fix the data entry application.

Another option in SQL Server if the # of characters to the left of the decimal are consistent is this:

SELECT Left('+9999665545.0000000000000000', 11)