I need to query against a column which contains build numbers stored as an NVARCHAR.Sorting works fine until you get into double-digit versions.This works ...

I have a table that lists phone numbers. I need them all to be in a specific format but I don't want to manually adjust the format.Correct format:(555)555-5555Incorrect format5555555555555-555 ...