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.
Roberts, IL Profile: Facts, Map & Data. Roberts, Illinois - Basic Facts. The Village of Roberts had a population of 366 as of July 1, 2016. The primary coordinate point for Roberts is located at latitude 40.6147 and longitude -88.1844 in Ford County. The formal boundaries for the Village of Roberts (see map below) encompass a land area of 0.49 sq. miles and a water area of 0 sq. miles.