Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
visa123
Yak Posting Veteran
54 Posts |
 Posted - 2011-01-24 : 03:34:33
|
| HiI am using the below query.But its showing Too many full-text columns or the full-text query.CityOnly field datatype i given varchar.The values total length is 2594 only.SELECT * FROM table1 WHERE contains(CityOnly,'"Addyston"OR"Alexandria"OR"Alpha"OR"Amelia"OR"Anderson"OR"Arlington Heights"OR"Augusta"OR"Aurora"OR"Avondale"OR"Batavia"OR"Batesville"OR"Bath"OR"Beavercreek"OR"Bellbrook"OR"Bellevue"OR"Bennington"OR"Bethel"OR"Blanchester"OR"Blanchet"OR"Blue Ash"OR"Boston"OR"Bromley"OR"Brooksville"OR"Brookville"OR"Brown County"OR"Brownsville"OR"Buford"OR"Burlington"OR"Butler"OR"California"OR"Camden"OR"Camp Dennison"OR"Canaan"OR"Carlisle"OR"Carrollton"OR"Cedar Grove"OR"Centerville"OR"Chilo"OR"Cincinnati"OR"Clarksville"OR"Clermont Cnty"OR"Clermont County"OR"Cleves"OR"Cold Spring"OR"Colerain Township"OR"College Corner"OR"College Hill"OR"Collinsville"OR"Corinth"OR"Covington"OR"Crescent Park"OR"Crescent Springs"OR"Crestview Hills"OR"Crittenden"OR"Cross Plains"OR"Cuba"OR"Day Heights"OR"Dayton"OR"De Mossville"OR"Decatur"OR"Dillsboro"OR"Dry Ridge"OR"East Enterprise"OR"Eaton"OR"Edgewood"OR"Elsmere"OR"Erlanger"OR"Fairfield"OR"Falmouth"OR"Farmersville"OR"Fayetteville"OR"Feesburg"OR"Felicity"OR"Florence"OR"Fort Mitchell"OR"Fort Thomas"OR"Fort Wright"OR"Foster"OR"Franklin"OR"Friendship"OR"Georgetown"OR"Germantown"OR"Ghent"OR"Glencoe"OR"Glendale"OR"Goshen"OR"Gratis"OR"Gratz"OR"Greendale"OR"Groesbeck"OR"Guilford"OR"Hamersville"OR"Hamilton"OR"Hamilton Township"OR"Harrison"OR"Harveysburg"OR"Hebron"OR"Higginsport"OR"Highland Heights"OR"Hillsboro"OR"Holton"OR"Hooven"OR"Independence"OR"Indian Springs"OR"Jonesville"OR"Kenton"OR"Kettering"OR"Kings Island"OR"Kings Mills"OR"Lakeside Park"OR"Latonia"OR"Latonia Lakes"OR"Laurel"OR"Lawrenceburg"OR"Lebanon"OR"Liberty"OR"Liberty Township"OR"Lindenwald"OR"Lockland"OR"Loveland"OR"Ludlow"OR"Lynchburg"OR"Madeira"OR"Maineville"OR"Marathon"OR"Martinsville"OR"Mason"OR"Melbourne"OR"Mentor"OR"Metamora"OR"Miamisburg"OR"Miamitown"OR"Miamiville"OR"Middletown"OR"Midland"OR"Milan"OR"Milford"OR"Minerva"OR"Monroe"OR"Montgomery"OR"Moores Hill"OR"Moraine"OR"Morning View"OR"Morris"OR"Morrow"OR"Moscow"OR"Mount Healthy"OR"Mount Olivet"OR"Mount Orab"OR"Mount Saint Joseph"OR"Mount Washington"OR"Mowrystown"OR"Napoleon"OR"Neville"OR"New Lebanon"OR"New Liberty"OR"New Point"OR"New Richmond"OR"New Trenton"OR"New Vienna"OR"Newport"OR"Newtonsville"OR"Newtown"OR"North Bend"OR"North College Hill"OR"Norwood"OR"Okeana"OR"Oldenburg"OR"Oregonia"OR"Osgood"OR"Overpeck"OR"Owen"OR"Owensville"OR"Owenton"OR"Oxford"OR"Park Hills"OR"Parkdale"OR"Patriot"OR"Pendleton County"OR"Perry Park"OR"Petersburg"OR"Pierceville"OR"Pleasant Plain"OR"Poetown"OR"Port Royal"OR"Port William"OR"Queen City"OR"Rabbit Hash"OR"Reading"OR"Ripley"OR"Rising Sun"OR"Roselawn"OR"Ross"OR"Rossville"OR"Rouse"OR"Russellville"OR"Ryland Heights"OR"Sadieville"OR"Saint Bernard"OR"Saint Leon"OR"Sanders"OR"Sardinia"OR"Sayler Park"OR"Seven Mile"OR"Shandon"OR"Sharonville"OR"Silver Grove"OR"Somerville"OR"South Fort Mitchell"OR"South Lebanon"OR"Southgate"OR"Sparta"OR"Spence"OR"Spring Valley"OR"Springboro"OR"Springdale"OR"Sunman"OR"Symmes"OR"Taft"OR"Taylor Mill"OR"Terrace Park"OR"Township of Washington"OR"Trenton"OR"Trotwood"OR"Union"OR"Verona"OR"Versailles"OR"Vevay"OR"Villa Hills"OR"Walnut Hills"OR"Walton"OR"Warsaw"OR"Waynesville"OR"West Alexandria"OR"West Carrollton"OR"West Chester"OR"West College Corner"OR"West Elkton"OR"West Harrison"OR"Westwood"OR"Wheatley"OR"Wilder"OR"Williamsburg"OR"Williamstown"OR"Wilmington"OR"Winchester"OR"Worthville"OR"Wyoming"OR"Xenia"') and contains(longState,'"Indiana"OR"Kentucky"OR"Ohio"') Can anyone help for this scenario?Visa.G |
|
|
|
|
|
Too many full-text columns or the full-text query