Pair Down List
Posted: Wed Jan 10, 2007 2:34 pm
I have a result set as follows:
CHEROKEE
CHEROKEE 4.0 L
CHEROKEE 4X4
CHEROKEE 4X4 LAREDO
CHEROKEE 4X4 LIMITED
CHEROKEE 4x4 SPORT
CHEROKEE 4X4SPORT
CHEROKEE CLASSIC
CHEROKEE CLASSIC 4WD
CHEROKEE CLASSIC 4X4
CHEROKEE CLASSIC CLASSIC
CHEROKEE CLASSIC LIMITED
CHEROKEE CLASSIC SPORT
CHEROKEE COUNTRY
CHEROKEE LARADEO
CHEROKEE LARED0
CHEROKEE LAREDO
CHEROKEE LIMITED
CHEROKEE LIMITED 4WD
CHEROKEE LIMITED 4X4
CHEROKEE LTD
CHEROKEE PIONEER
CHEROKEE SE
CHEROKEE SE 4X4
CHEROKEE SPORT
CHEROKEE SPORT 4 DR
CHEROKEE SPORT 4WD
CHEROKEE SPORT 4x4
CHEROKEE SPORT 60 YRS ED
CHEROKEE SPORT LIFTED
CHEROKEE SPORT V6
CJ5
CJ7
CJ7 4X4
CJ7 PLOW
COMANCHE
COMANCHE 4X4
COMANCHE PIONEER 4WD
COMMANDER
COMMANDER 2WD
COMMANDER 4wd
COMMANDER 4X4
How can I write my SELECT statement so that only CHEROKEE, CJ5, CJ7, COMANCHE and COMMANDER show up on my list? I'm doing this for searchablity so I can run searchs on LIKE %CHEROKEE% and have it return all of the above
CHEROKEE
CHEROKEE 4.0 L
CHEROKEE 4X4
CHEROKEE 4X4 LAREDO
CHEROKEE 4X4 LIMITED
CHEROKEE 4x4 SPORT
CHEROKEE 4X4SPORT
CHEROKEE CLASSIC
CHEROKEE CLASSIC 4WD
CHEROKEE CLASSIC 4X4
CHEROKEE CLASSIC CLASSIC
CHEROKEE CLASSIC LIMITED
CHEROKEE CLASSIC SPORT
CHEROKEE COUNTRY
CHEROKEE LARADEO
CHEROKEE LARED0
CHEROKEE LAREDO
CHEROKEE LIMITED
CHEROKEE LIMITED 4WD
CHEROKEE LIMITED 4X4
CHEROKEE LTD
CHEROKEE PIONEER
CHEROKEE SE
CHEROKEE SE 4X4
CHEROKEE SPORT
CHEROKEE SPORT 4 DR
CHEROKEE SPORT 4WD
CHEROKEE SPORT 4x4
CHEROKEE SPORT 60 YRS ED
CHEROKEE SPORT LIFTED
CHEROKEE SPORT V6
CJ5
CJ7
CJ7 4X4
CJ7 PLOW
COMANCHE
COMANCHE 4X4
COMANCHE PIONEER 4WD
COMMANDER
COMMANDER 2WD
COMMANDER 4wd
COMMANDER 4X4
How can I write my SELECT statement so that only CHEROKEE, CJ5, CJ7, COMANCHE and COMMANDER show up on my list? I'm doing this for searchablity so I can run searchs on LIKE %CHEROKEE% and have it return all of the above