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.
Orion, Illinois. Homefacts City Report. Orion is located in Henry County, IL. The population is 1,934, making Orion the 6th largest city in Henry County. There are 3 public schools in Orion with an average Homefacts rating of B+. The total crime rate for Orion is very low, and there are 3 registered sex offenders residing in the city.