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.
Located in La Salle county, Peru, Illinois, is 50 miles NE of Peoria, Illinois (center to center) and 84 miles SW of Chicago, Illinois. The city has a population of 9,835 residents. Peru History. The city's first settlers arrived in 1830, with John Hays being the first person to settle permanently in Peru. Over time, it became an important river port.