2224353 will be returned as 222-4353. The SQL Server STUFF function is used to replace certain characters with other characters, based on the position. For example STUFF(phno,1,1,'(') replaces the first character with '(' . Similarly STUFF(phno,6,1,') ') inserts ') ' after position 6.
Toledo, Illinois. Toledo is a village in Cumberland County, Illinois, United States. The population was 1,238 at the 2010 census. It is the county seat of Cumberland County. Toledo is part of the CharlestonâMattoon Micropolitan Statistical Area.
Perry County, Illinois Established January 29, 1827 ( Laws, 1827, page 110 ) - - - Perry County was formed in 1827 out of Jackson and Randolph Counties. It was named in honor of Oliver Hazard Perry who defeated the British fleet at the decisive Battle of Lake Erie in the War of 1812. Parts of Perry County were formerly included in : 1790-1803 - St. Clair County 1795-1827 - Randolph County 1816-1827 - Jackson County County Seat - Pinckneyville Approved June 1828 Early Perry County History