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.
Homefacts City Report. Palatine is located in Cook County, IL. The population is 69,254, making Palatine the 7th largest city in Cook County. There are 17 public schools in Palatine with an average Homefacts rating of B+. The total crime rate for Palatine is very low, and there are 26 registered sex offenders residing in the city.