Help with LIKE Statement - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Help with LIKE Statement

Author

Topic

mycotopian
Starting Member

5 Posts

Posted - 2006-07-19 : 13:01:46

I am having a little trouble with an access database I Am trying to query. I have a database of 200k account and a list of about 700 names that I need to pull from it. The best way I know would be to use a LIKE statement. When I tried to build a LIKE statement that long I get a "Syntax error (missing operator) in query expression". What is the most efficient way for me to build a query with a list of 600 names in excel?

humanpuck
Yak Posting Veteran

94 Posts

Posted - 2006-07-19 : 13:05:03

post the query you're trying.

mycotopian
Starting Member

5 Posts

Posted - 2006-07-19 : 13:05:25

FYI this is what I am using now which works but errors out when I add 600+ names to the list

WHERE
(`Leads 2006`.Borrower Like '%Lopez%') OR
(`Leads 2006`.Borrower Like '%Smith%') OR
(`Leads 2006`.Borrower Like '%Johnson%')

mycotopian
Starting Member

5 Posts

Posted - 2006-07-19 : 13:13:02

here is the entire query, sorry it's big

SELECT Results.AppraisalAmount, Results.Borrower, Results.BorrowerPhoneNumber, Results.BorrowerPhoneNumberWork, Results.DecisionFico, Results.LoanAmount, Results.LoanCreatedDate__YYYYMMDD, Results.LoanDocType, Results.LoanProductDescription, Results.PropertyAddress1, Results.PropertyAppraisedValue, Results.PropertyCity, Results.PropertyState, Results.PropertyZIP
FROM Results
WHERE
(`Leads 2006`.Borrower Like '% ABACHICHE%') OR
(`Leads 2006`.Borrower Like '% ABREGO%') OR
(`Leads 2006`.Borrower Like '% ACIAGA%') OR
(`Leads 2006`.Borrower Like '% ACOSTA%') OR
(`Leads 2006`.Borrower Like '% ADAMES%') OR
(`Leads 2006`.Borrower Like '% AGOSTINI%') OR
(`Leads 2006`.Borrower Like '% AGOSTO%') OR
(`Leads 2006`.Borrower Like '% AGRAZ%') OR
(`Leads 2006`.Borrower Like '% AGRELO%') OR
(`Leads 2006`.Borrower Like '% AGUILAR%') OR
(`Leads 2006`.Borrower Like '% AGUILERA%') OR
(`Leads 2006`.Borrower Like '% AGUIRRE%') OR
(`Leads 2006`.Borrower Like '% AIRLUCEA%') OR
(`Leads 2006`.Borrower Like '% AJA%') OR
(`Leads 2006`.Borrower Like '% ALBERT%') OR
(`Leads 2006`.Borrower Like '% ALBERT(O)%') OR
(`Leads 2006`.Borrower Like '% ALDAPE%') OR
(`Leads 2006`.Borrower Like '% ALDAYA%') OR
(`Leads 2006`.Borrower Like '% ALDEQUEVA%') OR
(`Leads 2006`.Borrower Like '% ALEJANDRO%') OR
(`Leads 2006`.Borrower Like '% ALEJO%') OR
(`Leads 2006`.Borrower Like '% ALEMAN%') OR
(`Leads 2006`.Borrower Like '% ALFONSO%') OR
(`Leads 2006`.Borrower Like '% ALMODOVAR%') OR
(`Leads 2006`.Borrower Like '% ALONSO%') OR
(`Leads 2006`.Borrower Like '% ALVARADO%') OR
(`Leads 2006`.Borrower Like '% ALVAREZ%') OR
(`Leads 2006`.Borrower Like '% AMOROS%') OR
(`Leads 2006`.Borrower Like '% ANDICHOCHEA%') OR
(`Leads 2006`.Borrower Like '% ANDREAS%') OR
(`Leads 2006`.Borrower Like '% ANDREW%') OR
(`Leads 2006`.Borrower Like '% ANDREWS%') OR
(`Leads 2006`.Borrower Like '% ANORO%') OR
(`Leads 2006`.Borrower Like '% APARICIO%') OR
(`Leads 2006`.Borrower Like '% AQUINO%') OR
(`Leads 2006`.Borrower Like '% ARAGON%') OR
(`Leads 2006`.Borrower Like '% ARBELO%') OR
(`Leads 2006`.Borrower Like '% ARBOLEDA%') OR
(`Leads 2006`.Borrower Like '% ARCE%') OR
(`Leads 2006`.Borrower Like '% ARCHULETA%') OR
(`Leads 2006`.Borrower Like '% ARENCEBIA%') OR
(`Leads 2006`.Borrower Like '% ARGUETA%') OR
(`Leads 2006`.Borrower Like '% ARMIJO%') OR
(`Leads 2006`.Borrower Like '% AROCHA%') OR
(`Leads 2006`.Borrower Like '% ARREDONDO%') OR
(`Leads 2006`.Borrower Like '% ARRIOLA%') OR
(`Leads 2006`.Borrower Like '% ARROCHA%') OR
(`Leads 2006`.Borrower Like '% ARROYO%') OR
(`Leads 2006`.Borrower Like '% ARTIEDA%') OR
(`Leads 2006`.Borrower Like '% ATILES%') OR
(`Leads 2006`.Borrower Like '% AUSTRIA%') OR
(`Leads 2006`.Borrower Like '% AVILA%') OR
(`Leads 2006`.Borrower Like '% AVILES%') OR
(`Leads 2006`.Borrower Like '% AYALA%') OR
(`Leads 2006`.Borrower Like '% AZCOIDI%') OR
(`Leads 2006`.Borrower Like '% B(P)LANCARTE%') OR
(`Leads 2006`.Borrower Like '% BACA%') OR
(`Leads 2006`.Borrower Like '% BACAS%') OR
(`Leads 2006`.Borrower Like '% BADIA%') OR
(`Leads 2006`.Borrower Like '% BAEZ%') OR
(`Leads 2006`.Borrower Like '% BAIES%') OR
(`Leads 2006`.Borrower Like '% BALDERAS%') OR
(`Leads 2006`.Borrower Like '% BALLESTER%') OR
(`Leads 2006`.Borrower Like '% BALLESTERO%') OR
(`Leads 2006`.Borrower Like '% BANUELOS%') OR
(`Leads 2006`.Borrower Like '% BAR%') OR
(`Leads 2006`.Borrower Like '% BARBA%') OR
(`Leads 2006`.Borrower Like '% BARELA%') OR
(`Leads 2006`.Borrower Like '% BARRAGAN%') OR
(`Leads 2006`.Borrower Like '% BARRAL%') OR
(`Leads 2006`.Borrower Like '% BARRANTES%') OR
(`Leads 2006`.Borrower Like '% BARRERA%') OR
(`Leads 2006`.Borrower Like '% BARRERAS%') OR
(`Leads 2006`.Borrower Like '% BARRETO%') OR
(`Leads 2006`.Borrower Like '% BARZAGA%') OR
(`Leads 2006`.Borrower Like '% BASSOLS%') OR
(`Leads 2006`.Borrower Like '% Bates%') OR
(`Leads 2006`.Borrower Like '% BAYON%') OR
(`Leads 2006`.Borrower Like '% BAYOT%') OR
(`Leads 2006`.Borrower Like '% BEJARANO%') OR
(`Leads 2006`.Borrower Like '% BENAVIDES%') OR
(`Leads 2006`.Borrower Like '% BENTECOURT%') OR
(`Leads 2006`.Borrower Like '% BERMUDEZ%') OR
(`Leads 2006`.Borrower Like '% BERNARDI%') OR
(`Leads 2006`.Borrower Like '% BERRADRE%') OR
(`Leads 2006`.Borrower Like '% BERUMEN%') OR
(`Leads 2006`.Borrower Like '% BETANCOURT%') OR
(`Leads 2006`.Borrower Like '% BIAR%') OR
(`Leads 2006`.Borrower Like '% BLANCO%') OR
(`Leads 2006`.Borrower Like '% BONANO%') OR
(`Leads 2006`.Borrower Like '% BONAPARET%') OR
(`Leads 2006`.Borrower Like '% BONASTRE%') OR
(`Leads 2006`.Borrower Like '% BONILLA%') OR
(`Leads 2006`.Borrower Like '% BORUNDA%') OR
(`Leads 2006`.Borrower Like '% BRAVO%') OR
(`Leads 2006`.Borrower Like '% BRETANA%') OR
(`Leads 2006`.Borrower Like '% BRINK%') OR
(`Leads 2006`.Borrower Like '% BRITO%') OR
(`Leads 2006`.Borrower Like '% BROULLON%') OR
(`Leads 2006`.Borrower Like '% BUELNA%') OR
(`Leads 2006`.Borrower Like '% BUENDIA%') OR
(`Leads 2006`.Borrower Like '% BURGOS%') OR
(`Leads 2006`.Borrower Like '% BURILLO%') OR
(`Leads 2006`.Borrower Like '% BURSET%') OR
(`Leads 2006`.Borrower Like '% BUSTERINO%') OR
(`Leads 2006`.Borrower Like '% BUTRON%') OR
(`Leads 2006`.Borrower Like '% BUXO%') OR
(`Leads 2006`.Borrower Like '% CAGIGAS%') OR
(`Leads 2006`.Borrower Like '% CALDERON%') OR
(`Leads 2006`.Borrower Like '% CALO%') OR
(`Leads 2006`.Borrower Like '% CALZADA%') OR
(`Leads 2006`.Borrower Like '% CAMACHO%') OR
(`Leads 2006`.Borrower Like '% CAMPANA%') OR
(`Leads 2006`.Borrower Like '% CAMPOS%') OR
(`Leads 2006`.Borrower Like '% CANALES%') OR
(`Leads 2006`.Borrower Like '% CANDELARIA%') OR
(`Leads 2006`.Borrower Like '% CANEZ%') OR
(`Leads 2006`.Borrower Like '% CANTU%') OR
(`Leads 2006`.Borrower Like '% CAPO%') OR
(`Leads 2006`.Borrower Like '% CAR(R)ILLO%') OR
(`Leads 2006`.Borrower Like '% CARBAJAL%') OR
(`Leads 2006`.Borrower Like '% CARDENAS%') OR
(`Leads 2006`.Borrower Like '% CARDOZA%') OR
(`Leads 2006`.Borrower Like '% CAREON%') OR
(`Leads 2006`.Borrower Like '% CARMONA%') OR
(`Leads 2006`.Borrower Like '% CARO%') OR
(`Leads 2006`.Borrower Like '% CARRANEO%') OR
(`Leads 2006`.Borrower Like '% CARRANZA%') OR
(`Leads 2006`.Borrower Like '% CARRIZALES%') OR
(`Leads 2006`.Borrower Like '% CARTAYA%') OR
(`Leads 2006`.Borrower Like '% CASARES%') OR
(`Leads 2006`.Borrower Like '% CASIANO%') OR
(`Leads 2006`.Borrower Like '% CASILLAS%') OR
(`Leads 2006`.Borrower Like '% CASTELLANO%') OR
(`Leads 2006`.Borrower Like '% CASTELLANOS%') OR
(`Leads 2006`.Borrower Like '% CASTILLA%') OR
(`Leads 2006`.Borrower Like '% CASTILLO%') OR
(`Leads 2006`.Borrower Like '% CASTRO%') OR
(`Leads 2006`.Borrower Like '% CATALAN%') OR
(`Leads 2006`.Borrower Like '% CAVASOS%') OR
(`Leads 2006`.Borrower Like '% CAVAZOS%') OR
(`Leads 2006`.Borrower Like '% CEBALLOS%') OR
(`Leads 2006`.Borrower Like '% CECILIO%') OR
(`Leads 2006`.Borrower Like '% CEL%') OR
(`Leads 2006`.Borrower Like '% CELAYA%') OR
(`Leads 2006`.Borrower Like '% CHAPA%') OR
(`Leads 2006`.Borrower Like '% CHAPARRO%') OR
(`Leads 2006`.Borrower Like '% CHARUM%') OR
(`Leads 2006`.Borrower Like '% CHAVES%') OR
(`Leads 2006`.Borrower Like '% CHAVEZ%') OR
(`Leads 2006`.Borrower Like '% CHINEA%') OR
(`Leads 2006`.Borrower Like '% CISNEROS%') OR
(`Leads 2006`.Borrower Like '% COBAS%') OR
(`Leads 2006`.Borrower Like '% COEDO%') OR
(`Leads 2006`.Borrower Like '% COFRESI%') OR
(`Leads 2006`.Borrower Like '% COLBERG%') OR
(`Leads 2006`.Borrower Like '% COLINA%') OR
(`Leads 2006`.Borrower Like '% COLLAZO%') OR
(`Leads 2006`.Borrower Like '% COLLERO%') OR
(`Leads 2006`.Borrower Like '% COLMAN%') OR
(`Leads 2006`.Borrower Like '% COLOMER%') OR
(`Leads 2006`.Borrower Like '% COLON%') OR
(`Leads 2006`.Borrower Like '% COMPEAN%') OR
(`Leads 2006`.Borrower Like '% CONDE%') OR
(`Leads 2006`.Borrower Like '% CONTRERAS%') OR
(`Leads 2006`.Borrower Like '% CORALES%') OR
(`Leads 2006`.Borrower Like '% CORBO%') OR
(`Leads 2006`.Borrower Like '% CORDERO%') OR
(`Leads 2006`.Borrower Like '% CORDOVA%') OR
(`Leads 2006`.Borrower Like '% CORREA%') OR
(`Leads 2006`.Borrower Like '% COVARRUBIAS%') OR
(`Leads 2006`.Borrower Like '% COY%') OR
(`Leads 2006`.Borrower Like '% CRUZ%') OR
(`Leads 2006`.Borrower Like '% CRUZADO%') OR
(`Leads 2006`.Borrower Like '% CUARTERO%') OR
(`Leads 2006`.Borrower Like '% CUELLAR%') OR
(`Leads 2006`.Borrower Like '% CUEN%') OR
(`Leads 2006`.Borrower Like '% CUERVO%') OR
(`Leads 2006`.Borrower Like '% CUEVAS%') OR
(`Leads 2006`.Borrower Like '% D%') OR
(`Leads 2006`.Borrower Like '% DABAN%') OR
(`Leads 2006`.Borrower Like '% DALMAU%') OR
(`Leads 2006`.Borrower Like '% D'AMORES%') OR
(`Leads 2006`.Borrower Like '% DAVALOS%') OR
(`Leads 2006`.Borrower Like '% DAVILA%') OR
(`Leads 2006`.Borrower Like '% DE%') OR
(`Leads 2006`.Borrower Like '% DECLET%') OR
(`Leads 2006`.Borrower Like '% DEL%') OR
(`Leads 2006`.Borrower Like '% DELEON%') OR
(`Leads 2006`.Borrower Like '% DELGADO%') OR
(`Leads 2006`.Borrower Like '% DELHOYO%') OR
(`Leads 2006`.Borrower Like '% DIANA%') OR
(`Leads 2006`.Borrower Like '% DIAZ%') OR
(`Leads 2006`.Borrower Like '% DISPIRITO%') OR
(`Leads 2006`.Borrower Like '% DOCAL%') OR
(`Leads 2006`.Borrower Like '% DOMINGUEZ%') OR
(`Leads 2006`.Borrower Like '% DUARTE%') OR
(`Leads 2006`.Borrower Like '% DUCLERC%') OR
(`Leads 2006`.Borrower Like '% DULZAIDES%') OR
(`Leads 2006`.Borrower Like '% DUQUE%') OR
(`Leads 2006`.Borrower Like '% DURAN%') OR
(`Leads 2006`.Borrower Like '% ECHEVARRIA%') OR
(`Leads 2006`.Borrower Like '% ECHEVERRIA%') OR
(`Leads 2006`.Borrower Like '% ELGUEZABAL%') OR
(`Leads 2006`.Borrower Like '% ELISONDO%') OR
(`Leads 2006`.Borrower Like '% ELIZONDO%') OR
(`Leads 2006`.Borrower Like '% EMANUELLI%') OR
(`Leads 2006`.Borrower Like '% EMERIC%') OR
(`Leads 2006`.Borrower Like '% EMMANUELLI%') OR
(`Leads 2006`.Borrower Like '% ENCINAS%') OR
(`Leads 2006`.Borrower Like '% ENRIQUEZ%') OR
(`Leads 2006`.Borrower Like '% ENTENZA%') OR
(`Leads 2006`.Borrower Like '% ESCOBAR%') OR
(`Leads 2006`.Borrower Like '% ESPARZA%') OR
(`Leads 2006`.Borrower Like '% ESPINOZA%') OR
(`Leads 2006`.Borrower Like '% ESPOSITO%') OR
(`Leads 2006`.Borrower Like '% ESQUILIN%') OR
(`Leads 2006`.Borrower Like '% ESTRADA%') OR
(`Leads 2006`.Borrower Like '% F%') OR
(`Leads 2006`.Borrower Like '% FANTAUZZI%') OR
(`Leads 2006`.Borrower Like '% FARIAS%') OR
(`Leads 2006`.Borrower Like '% FEBO%') OR
(`Leads 2006`.Borrower Like '% FELAN%') OR
(`Leads 2006`.Borrower Like '% FELICIANO%') OR
(`Leads 2006`.Borrower Like '% FELIN%') OR
(`Leads 2006`.Borrower Like '% FEO%') OR
(`Leads 2006`.Borrower Like '% FERNANDES%') OR
(`Leads 2006`.Borrower Like '% FERNANDEZ%') OR
(`Leads 2006`.Borrower Like '% FERRO%') OR
(`Leads 2006`.Borrower Like '% FIGUEREDO%') OR
(`Leads 2006`.Borrower Like '% FIGUEROA%') OR
(`Leads 2006`.Borrower Like '% FINADOS%') OR
(`Leads 2006`.Borrower Like '% FLEITES%') OR
(`Leads 2006`.Borrower Like '% FLORES%') OR
(`Leads 2006`.Borrower Like '% FOLLIN%') OR
(`Leads 2006`.Borrower Like '% FONSECA%') OR
(`Leads 2006`.Borrower Like '% FONTANES%') OR
(`Leads 2006`.Borrower Like '% FRANQUI%') OR
(`Leads 2006`.Borrower Like '% FRESCO%') OR
(`Leads 2006`.Borrower Like '% FUENTE%') OR
(`Leads 2006`.Borrower Like '% FUENTES%') OR
(`Leads 2006`.Borrower Like '% FURTADO%') OR
(`Leads 2006`.Borrower Like '% G%') OR
(`Leads 2006`.Borrower Like '% GAGINO%') OR
(`Leads 2006`.Borrower Like '% GALAN%') OR
(`Leads 2006`.Borrower Like '% GALEAS%') OR
(`Leads 2006`.Borrower Like '% GALIANO%') OR
(`Leads 2006`.Borrower Like '% GALINDEZ%') OR
(`Leads 2006`.Borrower Like '% GALINDO%') OR
(`Leads 2006`.Borrower Like '% GALLEGOS%') OR
(`Leads 2006`.Borrower Like '% GALVAN%') OR
(`Leads 2006`.Borrower Like '% GAMBAU%') OR
(`Leads 2006`.Borrower Like '% GARAY%') OR
(`Leads 2006`.Borrower Like '% GARCEZ%') OR
(`Leads 2006`.Borrower Like '% GARCIA%') OR
(`Leads 2006`.Borrower Like '% GARZA%') OR
(`Leads 2006`.Borrower Like '% GASTELUM%') OR
(`Leads 2006`.Borrower Like '% GAXIOLA%') OR
(`Leads 2006`.Borrower Like '% GAYME(S)%') OR
(`Leads 2006`.Borrower Like '% GAZTAMBIDE%') OR
(`Leads 2006`.Borrower Like '% GENUNDEZ%') OR
(`Leads 2006`.Borrower Like '% GERENA%') OR
(`Leads 2006`.Borrower Like '% GINORIO%') OR
(`Leads 2006`.Borrower Like '% GOMES%') OR
(`Leads 2006`.Borrower Like '% GOMEZ%') OR
(`Leads 2006`.Borrower Like '% GONGORA%') OR
(`Leads 2006`.Borrower Like '% GONI%') OR
(`Leads 2006`.Borrower Like '% GONSALES%') OR
(`Leads 2006`.Borrower Like '% GONSALVES%') OR
(`Leads 2006`.Borrower Like '% GONZALES%') OR
(`Leads 2006`.Borrower Like '% GONZALEZ%') OR
(`Leads 2006`.Borrower Like '% GRANADOS%') OR
(`Leads 2006`.Borrower Like '% GRIEGO%') OR
(`Leads 2006`.Borrower Like '% GUADALUPE%') OR
(`Leads 2006`.Borrower Like '% GUERRA%') OR
(`Leads 2006`.Borrower Like '% GUERRERO(A)%') OR
(`Leads 2006`.Borrower Like '% GURREA%') OR
(`Leads 2006`.Borrower Like '% GUTIERRES%') OR
(`Leads 2006`.Borrower Like '% GUTIERREZ%') OR
(`Leads 2006`.Borrower Like '% GUZMAN%') OR
(`Leads 2006`.Borrower Like '% HABER%') OR
(`Leads 2006`.Borrower Like '% HADDOCK%') OR
(`Leads 2006`.Borrower Like '% HAMMEKEN%') OR
(`Leads 2006`.Borrower Like '% HECTOR%') OR
(`Leads 2006`.Borrower Like '% HERMIDA%') OR
(`Leads 2006`.Borrower Like '% HERNANDES%') OR
(`Leads 2006`.Borrower Like '% HERNANDEZ%') OR
(`Leads 2006`.Borrower Like '% HERRERA%') OR
(`Leads 2006`.Borrower Like '% HIGUERA%') OR
(`Leads 2006`.Borrower Like '% HIGUERAS%') OR
(`Leads 2006`.Borrower Like '% HOLGUIN%') OR
(`Leads 2006`.Borrower Like '% HUERTA%') OR
(`Leads 2006`.Borrower Like '% HUESCA%') OR
(`Leads 2006`.Borrower Like '% HUEZO%') OR
(`Leads 2006`.Borrower Like '% HURTADO%') OR
(`Leads 2006`.Borrower Like '% JACINTO%') OR
(`Leads 2006`.Borrower Like '% JAIME%') OR
(`Leads 2006`.Borrower Like '% JAIME(S)%') OR
(`Leads 2006`.Borrower Like '% JAIMES%') OR
(`Leads 2006`.Borrower Like '% JAQUINDE%') OR
(`Leads 2006`.Borrower Like '% JAYME(S)%') OR
(`Leads 2006`.Borrower Like '% JIMENEZ%') OR
(`Leads 2006`.Borrower Like '% JOE%') OR
(`Leads 2006`.Borrower Like '% JORGE%') OR
(`Leads 2006`.Borrower Like '% JUAREZ%') OR
(`Leads 2006`.Borrower Like '% LAGARDA%') OR
(`Leads 2006`.Borrower Like '% LARA%') OR
(`Leads 2006`.Borrower Like '% LATORRE%') OR
(`Leads 2006`.Borrower Like '% LAUREANO%') OR
(`Leads 2006`.Borrower Like '% LAURENCO%') OR
(`Leads 2006`.Borrower Like '% LAVANDERO%') OR
(`Leads 2006`.Borrower Like '% LEAL%') OR
(`Leads 2006`.Borrower Like '% LEBRON%') OR
(`Leads 2006`.Borrower Like '% LED(O)UC%') OR
(`Leads 2006`.Borrower Like '% LEDESMA%') OR
(`Leads 2006`.Borrower Like '% LEDOUX%') OR
(`Leads 2006`.Borrower Like '% LENERO%') OR
(`Leads 2006`.Borrower Like '% LEON%') OR
(`Leads 2006`.Borrower Like '% LERMA%') OR
(`Leads 2006`.Borrower Like '% LEYBA%') OR
(`Leads 2006`.Borrower Like '% LIENDO%') OR
(`Leads 2006`.Borrower Like '% LIMA%') OR
(`Leads 2006`.Borrower Like '% LIZANA%') OR
(`Leads 2006`.Borrower Like '% LLAMAS%') OR
(`Leads 2006`.Borrower Like '% LONGORIA%') OR
(`Leads 2006`.Borrower Like '% LOPEZ%') OR
(`Leads 2006`.Borrower Like '% LOZA%') OR
(`Leads 2006`.Borrower Like '% LOZANO%') OR
(`Leads 2006`.Borrower Like '% LUCAS%') OR
(`Leads 2006`.Borrower Like '% LUCERO%') OR
(`Leads 2006`.Borrower Like '% LUJAN%') OR
(`Leads 2006`.Borrower Like '% MADRID%') OR
(`Leads 2006`.Borrower Like '% MAESTAS%') OR
(`Leads 2006`.Borrower Like '% MAEZ%') OR
(`Leads 2006`.Borrower Like '% MAGANA%') OR
(`Leads 2006`.Borrower Like '% MALDONADO%') OR
(`Leads 2006`.Borrower Like '% MALTES%') OR
(`Leads 2006`.Borrower Like '% MANGEL%') OR
(`Leads 2006`.Borrower Like '% MANRESA%') OR
(`Leads 2006`.Borrower Like '% MANZANERES%') OR
(`Leads 2006`.Borrower Like '% MARCANO%') OR
(`Leads 2006`.Borrower Like '% MARCHAND%') OR
(`Leads 2006`.Borrower Like '% MARMOL%') OR
(`Leads 2006`.Borrower Like '% MARQUEZ%') OR
(`Leads 2006`.Borrower Like '% MARRERO%') OR
(`Leads 2006`.Borrower Like '% MARTEL(L)%') OR
(`Leads 2006`.Borrower Like '% MARTI%') OR
(`Leads 2006`.Borrower Like '% MARTIN%') OR
(`Leads 2006`.Borrower Like '% MARTINEZ%') OR
(`Leads 2006`.Borrower Like '% MASFERRER%') OR
(`Leads 2006`.Borrower Like '% MAT(T)OS%') OR
(`Leads 2006`.Borrower Like '% MATEO%') OR
(`Leads 2006`.Borrower Like '% MATOS%') OR
(`Leads 2006`.Borrower Like '% MAULEN%') OR
(`Leads 2006`.Borrower Like '% MEDINA%') OR
(`Leads 2006`.Borrower Like '% MEDRANO%') OR
(`Leads 2006`.Borrower Like '% MEJIAS%') OR
(`Leads 2006`.Borrower Like '% MELENDEZ%') OR
(`Leads 2006`.Borrower Like '% MELIANS%') OR
(`Leads 2006`.Borrower Like '% MENA%') OR
(`Leads 2006`.Borrower Like '% MENASCO%') OR
(`Leads 2006`.Borrower Like '% MENCHACA%') OR
(`Leads 2006`.Borrower Like '% MENDEZ%') OR
(`Leads 2006`.Borrower Like '% MENDIVES%') OR
(`Leads 2006`.Borrower Like '% MENDOZA%') OR
(`Leads 2006`.Borrower Like '% MENENDEZ%') OR
(`Leads 2006`.Borrower Like '% MENTOYA%') OR
(`Leads 2006`.Borrower Like '% MERCADO%') OR
(`Leads 2006`.Borrower Like '% MEZA%') OR
(`Leads 2006`.Borrower Like '% MIGUEZ%') OR
(`Leads 2006`.Borrower Like '% MIR%') OR
(`Leads 2006`.Borrower Like '% MIRABAL%') OR
(`Leads 2006`.Borrower Like '% MIRANDA%') OR
(`Leads 2006`.Borrower Like '% MIRELES%') OR
(`Leads 2006`.Borrower Like '% MOLDONADO%') OR
(`Leads 2006`.Borrower Like '% MOLINA%') OR
(`Leads 2006`.Borrower Like '% MOLINAR%') OR
(`Leads 2006`.Borrower Like '% MONARRES%') OR
(`Leads 2006`.Borrower Like '% MONESTEL%') OR
(`Leads 2006`.Borrower Like '% MONGE%') OR
(`Leads 2006`.Borrower Like '% MONTALVO%') OR
(`Leads 2006`.Borrower Like '% MONTANEZ%') OR
(`Leads 2006`.Borrower Like '% MONTEAGUDO%') OR
(`Leads 2006`.Borrower Like '% MONTEMAYOR%') OR
(`Leads 2006`.Borrower Like '% MONTERO%') OR
(`Leads 2006`.Borrower Like '% MONTES%') OR
(`Leads 2006`.Borrower Like '% MONTOLLA%') OR
(`Leads 2006`.Borrower Like '% MONTOYA%') OR
(`Leads 2006`.Borrower Like '% MORA%') OR
(`Leads 2006`.Borrower Like '% MORAGA%') OR
(`Leads 2006`.Borrower Like '% MORALES%') OR
(`Leads 2006`.Borrower Like '% MOREIRA%') OR
(`Leads 2006`.Borrower Like '% MOREL%') OR
(`Leads 2006`.Borrower Like '% MORELES%') OR
(`Leads 2006`.Borrower Like '% MORENO%') OR
(`Leads 2006`.Borrower Like '% MORINGLANES%') OR
(`Leads 2006`.Borrower Like '% MOSQUEDA%') OR
(`Leads 2006`.Borrower Like '% MOSQUERA%') OR
(`Leads 2006`.Borrower Like '% MUNGUIA%') OR
(`Leads 2006`.Borrower Like '% MUNIZ%') OR
(`Leads 2006`.Borrower Like '% MUNOZ%') OR
(`Leads 2006`.Borrower Like '% MURILLO%') OR
(`Leads 2006`.Borrower Like '% MUZQUIZ%') OR
(`Leads 2006`.Borrower Like '% NAPOLES%') OR
(`Leads 2006`.Borrower Like '% NARANJO%') OR
(`Leads 2006`.Borrower Like '% NARRO%') OR
(`Leads 2006`.Borrower Like '% NASSI%') OR
(`Leads 2006`.Borrower Like '% NATAL%') OR
(`Leads 2006`.Borrower Like '% NAVAR%') OR
(`Leads 2006`.Borrower Like '% NAVARRO%') OR
(`Leads 2006`.Borrower Like '% NEGRON%') OR
(`Leads 2006`.Borrower Like '% NEIRA%') OR
(`Leads 2006`.Borrower Like '% NIEGO%') OR
(`Leads 2006`.Borrower Like '% NIEVES%') OR
(`Leads 2006`.Borrower Like '% NOLLA%') OR
(`Leads 2006`.Borrower Like '% NUNEZ%') OR
(`Leads 2006`.Borrower Like '% OCASIO%') OR
(`Leads 2006`.Borrower Like '% OCHOA%') OR
(`Leads 2006`.Borrower Like '% O'CROULEY%') OR
(`Leads 2006`.Borrower Like '% O'DONOJU'%') OR
(`Leads 2006`.Borrower Like '% OGAZON%') OR
(`Leads 2006`.Borrower Like '% OJEDA%') OR
(`Leads 2006`.Borrower Like '% OLIVAREZ%') OR
(`Leads 2006`.Borrower Like '% OLIVERA%') OR
(`Leads 2006`.Borrower Like '% OLMOS%') OR
(`Leads 2006`.Borrower Like '% OLVEDA%') OR
(`Leads 2006`.Borrower Like '% ORELLANA%') OR
(`Leads 2006`.Borrower Like '% ORIA%') OR
(`Leads 2006`.Borrower Like '% ORLANDO%') OR
(`Leads 2006`.Borrower Like '% ORNELAS%') OR
(`Leads 2006`.Borrower Like '% OROS(Z)CO%') OR
(`Leads 2006`.Borrower Like '% ORTEGON%') OR
(`Leads 2006`.Borrower Like '% ORTIS%') OR
(`Leads 2006`.Borrower Like '% ORTIZ%') OR
(`Leads 2006`.Borrower Like '% OSLAN%') OR
(`Leads 2006`.Borrower Like '% P%') OR
(`Leads 2006`.Borrower Like '% PABON%') OR
(`Leads 2006`.Borrower Like '% PACHECO%') OR
(`Leads 2006`.Borrower Like '% PADILLA%') OR
(`Leads 2006`.Borrower Like '% PAESA%') OR
(`Leads 2006`.Borrower Like '% PAGAN%') OR
(`Leads 2006`.Borrower Like '% PALMA%') OR
(`Leads 2006`.Borrower Like '% PAMIAS%') OR
(`Leads 2006`.Borrower Like '% PANAIGUA%') OR
(`Leads 2006`.Borrower Like '% PAPI%') OR
(`Leads 2006`.Borrower Like '% PARADA%') OR
(`Leads 2006`.Borrower Like '% PARAMO%') OR
(`Leads 2006`.Borrower Like '% PAREDES%') OR
(`Leads 2006`.Borrower Like '% PARILLA%') OR
(`Leads 2006`.Borrower Like '% PASANDIN%') OR
(`Leads 2006`.Borrower Like '% PASQUAL%') OR
(`Leads 2006`.Borrower Like '% PATILLO%') OR
(`Leads 2006`.Borrower Like '% PaVa%') OR
(`Leads 2006`.Borrower Like '% PAZ%') OR
(`Leads 2006`.Borrower Like '% PEDRERO%') OR
(`Leads 2006`.Borrower Like '% PELI(N)%') OR
(`Leads 2006`.Borrower Like '% PELLOT%') OR
(`Leads 2006`.Borrower Like '% PELTRO%') OR
(`Leads 2006`.Borrower Like '% PENA%') OR
(`Leads 2006`.Borrower Like '% PENALVER%') OR
(`Leads 2006`.Borrower Like '% PERALTA%') OR
(`Leads 2006`.Borrower Like '% PEREA%') OR
(`Leads 2006`.Borrower Like '% PEREIRA%') OR
(`Leads 2006`.Borrower Like '% PEREZ%') OR
(`Leads 2006`.Borrower Like '% PERILLAN%') OR
(`Leads 2006`.Borrower Like '% PERPINAN%') OR
(`Leads 2006`.Borrower Like '% PESCINA%') OR
(`Leads 2006`.Borrower Like '% PINION%') OR
(`Leads 2006`.Borrower Like '% PINZON%') OR
(`Leads 2006`.Borrower Like '% PIOQUINTO%') OR
(`Leads 2006`.Borrower Like '% PIZANA%') OR
(`Leads 2006`.Borrower Like '% PLACENTIA%') OR
(`Leads 2006`.Borrower Like '% POMBO%') OR
(`Leads 2006`.Borrower Like '% PORTILLO%') OR
(`Leads 2006`.Borrower Like '% PORTOCARRERO%') OR
(`Leads 2006`.Borrower Like '% PRIETO%') OR
(`Leads 2006`.Borrower Like '% PROVENCIO%') OR
(`Leads 2006`.Borrower Like '% PUGA%') OR
(`Leads 2006`.Borrower Like '% PUIG%') OR
(`Leads 2006`.Borrower Like '% PUMARADA%') OR
(`Leads 2006`.Borrower Like '% QUERPIS%') OR
(`Leads 2006`.Borrower Like '% QUINONES%') OR
(`Leads 2006`.Borrower Like '% QUINONEZ%') OR
(`Leads 2006`.Borrower Like '% QUINTANA%') OR
(`Leads 2006`.Borrower Like '% QUINTANILLA%') OR
(`Leads 2006`.Borrower Like '% RABELO%') OR
(`Leads 2006`.Borrower Like '% RAMBRO%') OR
(`Leads 2006`.Borrower Like '% RAMIREZ%') OR
(`Leads 2006`.Borrower Like '% RAMOS%') OR
(`Leads 2006`.Borrower Like '% RATNER%') OR
(`Leads 2006`.Borrower Like '% RAYAS%') OR
(`Leads 2006`.Borrower Like '% REBEIRO%') OR
(`Leads 2006`.Borrower Like '% REBOYRO%') OR
(`Leads 2006`.Borrower Like '% REDONDO%') OR
(`Leads 2006`.Borrower Like '% RENDON%') OR
(`Leads 2006`.Borrower Like '% RENTA%') OR
(`Leads 2006`.Borrower Like '% REYES%') OR
(`Leads 2006`.Borrower Like '% RICO%') OR
(`Leads 2006`.Borrower Like '% RIOJAS%') OR
(`Leads 2006`.Borrower Like '% RIOS%') OR
(`Leads 2006`.Borrower Like '% RIQUELME%') OR
(`Leads 2006`.Borrower Like '% RIVERA%') OR
(`Leads 2006`.Borrower Like '% RIVERO%') OR
(`Leads 2006`.Borrower Like '% ROBLES%') OR
(`Leads 2006`.Borrower Like '% ROCHA%') OR
(`Leads 2006`.Borrower Like '% RODEO%') OR
(`Leads 2006`.Borrower Like '% RODRIGUEZ%') OR
(`Leads 2006`.Borrower Like '% ROERIDO%') OR
(`Leads 2006`.Borrower Like '% ROIG%') OR
(`Leads 2006`.Borrower Like '% ROMAN%') OR
(`Leads 2006`.Borrower Like '% ROMBRO%') OR
(`Leads 2006`.Borrower Like '% ROMERO%') OR
(`Leads 2006`.Borrower Like '% RONDA%') OR
(`Leads 2006`.Borrower Like '% ROQUIERO%') OR
(`Leads 2006`.Borrower Like '% ROS%') OR
(`Leads 2006`.Borrower Like '% ROSA%') OR
(`Leads 2006`.Borrower Like '% ROSADO%') OR
(`Leads 2006`.Borrower Like '% ROSALES%') OR
(`Leads 2006`.Borrower Like '% ROSARIO%') OR
(`Leads 2006`.Borrower Like '% ROSELLO%') OR
(`Leads 2006`.Borrower Like '% ROSILLO%') OR
(`Leads 2006`.Borrower Like '% RUANO%') OR
(`Leads 2006`.Borrower Like '% RUCAVADO%') OR
(`Leads 2006`.Borrower Like '% RUEDA%') OR
(`Leads 2006`.Borrower Like '% RUIZ%') OR
(`Leads 2006`.Borrower Like '% RUPERTO%') OR
(`Leads 2006`.Borrower Like '% SABATER%') OR
(`Leads 2006`.Borrower Like '% SAENZ%') OR
(`Leads 2006`.Borrower Like '% SAEZ%') OR
(`Leads 2006`.Borrower Like '% SAIS%') OR
(`Leads 2006`.Borrower Like '% SALAIS%') OR
(`Leads 2006`.Borrower Like '% SALAZAR%') OR
(`Leads 2006`.Borrower Like '% SALICHS%') OR
(`Leads 2006`.Borrower Like '% SALINAS%') OR
(`Leads 2006`.Borrower Like '% SALOMON%') OR
(`Leads 2006`.Borrower Like '% SAMANIEGO%') OR
(`Leads 2006`.Borrower Like '% SAN%') OR
(`Leads 2006`.Borrower Like '% SANABRIA%') OR
(`Leads 2006`.Borrower Like '% SANCHEZ%') OR
(`Leads 2006`.Borrower Like '% SANTA%') OR
(`Leads 2006`.Borrower Like '% SANTIAGO%') OR
(`Leads 2006`.Borrower Like '% SANTIESTEBAN%') OR
(`Leads 2006`.Borrower Like '% SANTINI%') OR
(`Leads 2006`.Borrower Like '% SANTOS%') OR
(`Leads 2006`.Borrower Like '% SANTOYO%') OR
(`Leads 2006`.Borrower Like '% SANZ%') OR
(`Leads 2006`.Borrower Like '% SARACEN%') OR
(`Leads 2006`.Borrower Like '% SARDINAS%') OR
(`Leads 2006`.Borrower Like '% SEANEZ%') OR
(`Leads 2006`.Borrower Like '% SEPOLIO%') OR
(`Leads 2006`.Borrower Like '% SEPULVEDA%') OR
(`Leads 2006`.Borrower Like '% SERENIL%') OR
(`Leads 2006`.Borrower Like '% SERNA%') OR
(`Leads 2006`.Borrower Like '% SERRANO%') OR
(`Leads 2006`.Borrower Like '% SEVILLA%') OR
(`Leads 2006`.Borrower Like '% SILVA%') OR
(`Leads 2006`.Borrower Like '% SIMEON%') OR
(`Leads 2006`.Borrower Like '% SMITH%') OR
(`Leads 2006`.Borrower Like '% SOLACHE%') OR
(`Leads 2006`.Borrower Like '% SOLTERO%') OR
(`Leads 2006`.Borrower Like '% SOTERA%') OR
(`Leads 2006`.Borrower Like '% SOTO%') OR
(`Leads 2006`.Borrower Like '% SOTTO%') OR
(`Leads 2006`.Borrower Like '% SOUFFRONT%') OR
(`Leads 2006`.Borrower Like '% SUAREZ%') OR
(`Leads 2006`.Borrower Like '% SURILLO%') OR
(`Leads 2006`.Borrower Like '% T(H)OMAS%') OR
(`Leads 2006`.Borrower Like '% TACORONTE%') OR
(`Leads 2006`.Borrower Like '% TAMAYO%') OR
(`Leads 2006`.Borrower Like '% TAMEZ%') OR
(`Leads 2006`.Borrower Like '% TEE%') OR
(`Leads 2006`.Borrower Like '% TEJADA%') OR
(`Leads 2006`.Borrower Like '% TERLAJE%') OR
(`Leads 2006`.Borrower Like '% TESORO%') OR
(`Leads 2006`.Borrower Like '% TIE%') OR
(`Leads 2006`.Borrower Like '% TIJERINA%') OR
(`Leads 2006`.Borrower Like '% TIRADO%') OR
(`Leads 2006`.Borrower Like '% TOBAJAS%') OR
(`Leads 2006`.Borrower Like '% TOIMIL%') OR
(`Leads 2006`.Borrower Like '% TORO%') OR
(`Leads 2006`.Borrower Like '% TORRES%') OR
(`Leads 2006`.Borrower Like '% TORREZ%') OR
(`Leads 2006`.Borrower Like '% TOVAR%') OR
(`Leads 2006`.Borrower Like '% TRAVESIER%') OR
(`Leads 2006`.Borrower Like '% TRESSARIEU%') OR
(`Leads 2006`.Borrower Like '% TREVINO%') OR
(`Leads 2006`.Borrower Like '% TRUJILLO%') OR
(`Leads 2006`.Borrower Like '% Tx%') OR
(`Leads 2006`.Borrower Like '% UBEDA%') OR
(`Leads 2006`.Borrower Like '% UMPIERE%') OR
(`Leads 2006`.Borrower Like '% URREA%') OR
(`Leads 2006`.Borrower Like '% URRUTIA%') OR
(`Leads 2006`.Borrower Like '% URTADO%') OR
(`Leads 2006`.Borrower Like '% USMC%') OR
(`Leads 2006`.Borrower Like '% VALADEZ%') OR
(`Leads 2006`.Borrower Like '% VALDES%') OR
(`Leads 2006`.Borrower Like '% VALDEZ%') OR
(`Leads 2006`.Borrower Like '% VALENCIA%') OR
(`Leads 2006`.Borrower Like '% VALENSULA%') OR
(`Leads 2006`.Borrower Like '% VALENTIN%') OR
(`Leads 2006`.Borrower Like '% VALENZUELA%') OR
(`Leads 2006`.Borrower Like '% VALERIO%') OR
(`Leads 2006`.Borrower Like '% VALERO%') OR
(`Leads 2006`.Borrower Like '% VALLE%') OR
(`Leads 2006`.Borrower Like '% VARELA%') OR
(`Leads 2006`.Borrower Like '% VARGAS%') OR
(`Leads 2006`.Borrower Like '% VASQUEZ%') OR
(`Leads 2006`.Borrower Like '% VAZQUEZ%') OR
(`Leads 2006`.Borrower Like '% VEGA%') OR
(`Leads 2006`.Borrower Like '% VELAZCO%') OR
(`Leads 2006`.Borrower Like '% VELEZ%') OR
(`Leads 2006`.Borrower Like '% VERDUGO%') OR
(`Leads 2006`.Borrower Like '% VERGARA%') OR
(`Leads 2006`.Borrower Like '% VERONA%') OR
(`Leads 2006`.Borrower Like '% VIDAL%') OR
(`Leads 2006`.Borrower Like '% VIEYRA%') OR
(`Leads 2006`.Borrower Like '% VILLA%') OR
(`Leads 2006`.Borrower Like '% VILLA(R)MARZO%') OR
(`Leads 2006`.Borrower Like '% VILLACRES%') OR
(`Leads 2006`.Borrower Like '% VILLAGRAN%') OR
(`Leads 2006`.Borrower Like '% VILLALOBOS%') OR
(`Leads 2006`.Borrower Like '% VILLALONGO%') OR
(`Leads 2006`.Borrower Like '% VILLALPANDO%') OR
(`Leads 2006`.Borrower Like '% VILLAMIL%') OR
(`Leads 2006`.Borrower Like '% VILLAREAL%') OR
(`Leads 2006`.Borrower Like '% VILLARREAL%') OR
(`Leads 2006`.Borrower Like '% VILLARUELLE%') OR
(`Leads 2006`.Borrower Like '% VILLASENOR%') OR
(`Leads 2006`.Borrower Like '% VILLEGAS%') OR
(`Leads 2006`.Borrower Like '% VINENT%') OR
(`Leads 2006`.Borrower Like '% VIVONI%') OR
(`Leads 2006`.Borrower Like '% VIZCARRA%') OR
(`Leads 2006`.Borrower Like '% VIZCAYA%') OR
(`Leads 2006`.Borrower Like '% YANEZ%') OR
(`Leads 2006`.Borrower Like '% YBARBO%') OR
(`Leads 2006`.Borrower Like '% ZABALA%') OR
(`Leads 2006`.Borrower Like '% ZAMARONO%') OR
(`Leads 2006`.Borrower Like '% ZAPATA%') OR
(`Leads 2006`.Borrower Like '% ZAPIEN%') OR
(`Leads 2006`.Borrower Like '% ZELAYA%') OR
(`Leads 2006`.Borrower Like '% ZERTUCHE%') OR
(`Leads 2006`.Borrower Like '% ZUNIGA%')

ORDER BY Results.LoanAmount, Results.DecisionFico;

humanpuck
Yak Posting Veteran

94 Posts

Posted - 2006-07-19 : 13:14:26

No way there's a typo? A missing OR somewhere? do you have any other conditions in your where clause?

humanpuck
Yak Posting Veteran

94 Posts

Posted - 2006-07-19 : 13:24:25

The only thing I can really think of is seeing how far you can go before you get that error, and then run batches.

mycotopian
Starting Member

5 Posts

Posted - 2006-07-19 : 13:31:22

Okay I noticed a typo in the last query I posted so I made a couple changes. Now I get an error saying my query is too complex.

SELECT Results.AppraisalAmount, Results.Borrower, Results.BorrowerPhoneNumber, Results.BorrowerPhoneNumberWork, Results.DecisionFico, Results.LoanAmount, Results.LoanCreatedDate__YYYYMMDD, Results.LoanDocType, Results.LoanProductDescription, Results.PropertyAddress1, Results.PropertyAppraisedValue, Results.PropertyCity, Results.PropertyState, Results.PropertyZIP
FROM Results
WHERE
Results.Borrower Like '% ABACHICHE%' OR
Results.Borrower Like '% ABREGO%' OR
Results.Borrower Like '% ACIAGA%' OR
Results.Borrower Like '% ACOSTA%' OR
Results.Borrower Like '% ADAMES%' OR
Results.Borrower Like '% AGOSTINI%' OR
Results.Borrower Like '% AGOSTO%' OR
Results.Borrower Like '% AGRAZ%' OR
Results.Borrower Like '% AGRELO%' OR
Results.Borrower Like '% AGUILAR%' OR
Results.Borrower Like '% AGUILERA%' OR
Results.Borrower Like '% AGUIRRE%' OR
Results.Borrower Like '% AIRLUCEA%' OR
Results.Borrower Like '% AJA%' OR
Results.Borrower Like '% ALBERT%' OR
Results.Borrower Like '% ALBERT(O)%' OR
Results.Borrower Like '% ALDAPE%' OR
Results.Borrower Like '% ALDAYA%' OR
Results.Borrower Like '% ALDEQUEVA%' OR
Results.Borrower Like '% ALEJANDRO%' OR
Results.Borrower Like '% ALEJO%' OR
Results.Borrower Like '% ALEMAN%' OR
Results.Borrower Like '% ALFONSO%' OR
Results.Borrower Like '% ALMODOVAR%' OR
Results.Borrower Like '% ALONSO%' OR
Results.Borrower Like '% ALVARADO%' OR
Results.Borrower Like '% ALVAREZ%' OR
Results.Borrower Like '% AMOROS%' OR
Results.Borrower Like '% ANDICHOCHEA%' OR
Results.Borrower Like '% ANDREAS%' OR
Results.Borrower Like '% ANDREW%' OR
Results.Borrower Like '% ANDREWS%' OR
Results.Borrower Like '% ANORO%' OR
Results.Borrower Like '% APARICIO%' OR
Results.Borrower Like '% AQUINO%' OR
Results.Borrower Like '% ARAGON%' OR
Results.Borrower Like '% ARBELO%' OR
Results.Borrower Like '% ARBOLEDA%' OR
Results.Borrower Like '% ARCE%' OR
Results.Borrower Like '% ARCHULETA%' OR
Results.Borrower Like '% ARENCEBIA%' OR
Results.Borrower Like '% ARGUETA%' OR
Results.Borrower Like '% ARMIJO%' OR
Results.Borrower Like '% AROCHA%' OR
Results.Borrower Like '% ARREDONDO%' OR
Results.Borrower Like '% ARRIOLA%' OR
Results.Borrower Like '% ARROCHA%' OR
Results.Borrower Like '% ARROYO%' OR
Results.Borrower Like '% ARTIEDA%' OR
Results.Borrower Like '% ATILES%' OR
Results.Borrower Like '% AUSTRIA%' OR
Results.Borrower Like '% AVILA%' OR
Results.Borrower Like '% AVILES%' OR
Results.Borrower Like '% AYALA%' OR
Results.Borrower Like '% AZCOIDI%' OR
Results.Borrower Like '% B(P)LANCARTE%' OR
Results.Borrower Like '% BACA%' OR
Results.Borrower Like '% BACAS%' OR
Results.Borrower Like '% BADIA%' OR
Results.Borrower Like '% BAEZ%' OR
Results.Borrower Like '% BAIES%' OR
Results.Borrower Like '% BALDERAS%' OR
Results.Borrower Like '% BALLESTER%' OR
Results.Borrower Like '% BALLESTERO%' OR
Results.Borrower Like '% BANUELOS%' OR
Results.Borrower Like '% BAR%' OR
Results.Borrower Like '% BARBA%' OR
Results.Borrower Like '% BARELA%' OR
Results.Borrower Like '% BARRAGAN%' OR
Results.Borrower Like '% BARRAL%' OR
Results.Borrower Like '% BARRANTES%' OR
Results.Borrower Like '% BARRERA%' OR
Results.Borrower Like '% BARRERAS%' OR
Results.Borrower Like '% BARRETO%' OR
Results.Borrower Like '% BARZAGA%' OR
Results.Borrower Like '% BASSOLS%' OR
Results.Borrower Like '% Bates%' OR
Results.Borrower Like '% BAYON%' OR
Results.Borrower Like '% BAYOT%' OR
Results.Borrower Like '% BEJARANO%' OR
Results.Borrower Like '% BENAVIDES%' OR
Results.Borrower Like '% BENTECOURT%' OR
Results.Borrower Like '% BERMUDEZ%' OR
Results.Borrower Like '% BERNARDI%' OR
Results.Borrower Like '% BERRADRE%' OR
Results.Borrower Like '% BERUMEN%' OR
Results.Borrower Like '% BETANCOURT%' OR
Results.Borrower Like '% BIAR%' OR
Results.Borrower Like '% BLANCO%' OR
Results.Borrower Like '% BONANO%' OR
Results.Borrower Like '% BONAPARET%' OR
Results.Borrower Like '% BONASTRE%' OR
Results.Borrower Like '% BONILLA%' OR
Results.Borrower Like '% BORUNDA%' OR
Results.Borrower Like '% BRAVO%' OR
Results.Borrower Like '% BRETANA%' OR
Results.Borrower Like '% BRINK%' OR
Results.Borrower Like '% BRITO%' OR
Results.Borrower Like '% BROULLON%' OR
Results.Borrower Like '% BUELNA%' OR
Results.Borrower Like '% BUENDIA%' OR
Results.Borrower Like '% BURGOS%' OR
Results.Borrower Like '% BURILLO%' OR
Results.Borrower Like '% BURSET%' OR
Results.Borrower Like '% BUSTERINO%' OR
Results.Borrower Like '% BUTRON%' OR
Results.Borrower Like '% BUXO%' OR
Results.Borrower Like '% CAGIGAS%' OR
Results.Borrower Like '% CALDERON%' OR
Results.Borrower Like '% CALO%' OR
Results.Borrower Like '% CALZADA%' OR
Results.Borrower Like '% CAMACHO%' OR
Results.Borrower Like '% CAMPANA%' OR
Results.Borrower Like '% CAMPOS%' OR
Results.Borrower Like '% CANALES%' OR
Results.Borrower Like '% CANDELARIA%' OR
Results.Borrower Like '% CANEZ%' OR
Results.Borrower Like '% CANTU%' OR
Results.Borrower Like '% CAPO%' OR
Results.Borrower Like '% CAR(R)ILLO%' OR
Results.Borrower Like '% CARBAJAL%' OR
Results.Borrower Like '% CARDENAS%' OR
Results.Borrower Like '% CARDOZA%' OR
Results.Borrower Like '% CAREON%' OR
Results.Borrower Like '% CARMONA%' OR
Results.Borrower Like '% CARO%' OR
Results.Borrower Like '% CARRANEO%' OR
Results.Borrower Like '% CARRANZA%' OR
Results.Borrower Like '% CARRIZALES%' OR
Results.Borrower Like '% CARTAYA%' OR
Results.Borrower Like '% CASARES%' OR
Results.Borrower Like '% CASIANO%' OR
Results.Borrower Like '% CASILLAS%' OR
Results.Borrower Like '% CASTELLANO%' OR
Results.Borrower Like '% CASTELLANOS%' OR
Results.Borrower Like '% CASTILLA%' OR
Results.Borrower Like '% CASTILLO%' OR
Results.Borrower Like '% CASTRO%' OR
Results.Borrower Like '% CATALAN%' OR
Results.Borrower Like '% CAVASOS%' OR
Results.Borrower Like '% CAVAZOS%' OR
Results.Borrower Like '% CEBALLOS%' OR
Results.Borrower Like '% CECILIO%' OR
Results.Borrower Like '% CEL%' OR
Results.Borrower Like '% CELAYA%' OR
Results.Borrower Like '% CHAPA%' OR
Results.Borrower Like '% CHAPARRO%' OR
Results.Borrower Like '% CHARUM%' OR
Results.Borrower Like '% CHAVES%' OR
Results.Borrower Like '% CHAVEZ%' OR
Results.Borrower Like '% CHINEA%' OR
Results.Borrower Like '% CISNEROS%' OR
Results.Borrower Like '% COBAS%' OR
Results.Borrower Like '% COEDO%' OR
Results.Borrower Like '% COFRESI%' OR
Results.Borrower Like '% COLBERG%' OR
Results.Borrower Like '% COLINA%' OR
Results.Borrower Like '% COLLAZO%' OR
Results.Borrower Like '% COLLERO%' OR
Results.Borrower Like '% COLMAN%' OR
Results.Borrower Like '% COLOMER%' OR
Results.Borrower Like '% COLON%' OR
Results.Borrower Like '% COMPEAN%' OR
Results.Borrower Like '% CONDE%' OR
Results.Borrower Like '% CONTRERAS%' OR
Results.Borrower Like '% CORALES%' OR
Results.Borrower Like '% CORBO%' OR
Results.Borrower Like '% CORDERO%' OR
Results.Borrower Like '% CORDOVA%' OR
Results.Borrower Like '% CORREA%' OR
Results.Borrower Like '% COVARRUBIAS%' OR
Results.Borrower Like '% COY%' OR
Results.Borrower Like '% CRUZ%' OR
Results.Borrower Like '% CRUZADO%' OR
Results.Borrower Like '% CUARTERO%' OR
Results.Borrower Like '% CUELLAR%' OR
Results.Borrower Like '% CUEN%' OR
Results.Borrower Like '% CUERVO%' OR
Results.Borrower Like '% CUEVAS%' OR
Results.Borrower Like '% D%' OR
Results.Borrower Like '% DABAN%' OR
Results.Borrower Like '% DALMAU%' OR
Results.Borrower Like '% DAVALOS%' OR
Results.Borrower Like '% DAVILA%' OR
Results.Borrower Like '% DE%' OR
Results.Borrower Like '% DECLET%' OR
Results.Borrower Like '% DEL%' OR
Results.Borrower Like '% DELEON%' OR
Results.Borrower Like '% DELGADO%' OR
Results.Borrower Like '% DELHOYO%' OR
Results.Borrower Like '% DIANA%' OR
Results.Borrower Like '% DIAZ%' OR
Results.Borrower Like '% DISPIRITO%' OR
Results.Borrower Like '% DOCAL%' OR
Results.Borrower Like '% DOMINGUEZ%' OR
Results.Borrower Like '% DUARTE%' OR
Results.Borrower Like '% DUCLERC%' OR
Results.Borrower Like '% DULZAIDES%' OR
Results.Borrower Like '% DUQUE%' OR
Results.Borrower Like '% DURAN%' OR
Results.Borrower Like '% ECHEVARRIA%' OR
Results.Borrower Like '% ECHEVERRIA%' OR
Results.Borrower Like '% ELGUEZABAL%' OR
Results.Borrower Like '% ELISONDO%' OR
Results.Borrower Like '% ELIZONDO%' OR
Results.Borrower Like '% EMANUELLI%' OR
Results.Borrower Like '% EMERIC%' OR
Results.Borrower Like '% EMMANUELLI%' OR
Results.Borrower Like '% ENCINAS%' OR
Results.Borrower Like '% ENRIQUEZ%' OR
Results.Borrower Like '% ENTENZA%' OR
Results.Borrower Like '% ESCOBAR%' OR
Results.Borrower Like '% ESPARZA%' OR
Results.Borrower Like '% ESPINOZA%' OR
Results.Borrower Like '% ESPOSITO%' OR
Results.Borrower Like '% ESQUILIN%' OR
Results.Borrower Like '% ESTRADA%' OR
Results.Borrower Like '% F%' OR
Results.Borrower Like '% FANTAUZZI%' OR
Results.Borrower Like '% FARIAS%' OR
Results.Borrower Like '% FEBO%' OR
Results.Borrower Like '% FELAN%' OR
Results.Borrower Like '% FELICIANO%' OR
Results.Borrower Like '% FELIN%' OR
Results.Borrower Like '% FEO%' OR
Results.Borrower Like '% FERNANDES%' OR
Results.Borrower Like '% FERNANDEZ%' OR
Results.Borrower Like '% FERRO%' OR
Results.Borrower Like '% FIGUEREDO%' OR
Results.Borrower Like '% FIGUEROA%' OR
Results.Borrower Like '% FINADOS%' OR
Results.Borrower Like '% FLEITES%' OR
Results.Borrower Like '% FLORES%' OR
Results.Borrower Like '% FOLLIN%' OR
Results.Borrower Like '% FONSECA%' OR
Results.Borrower Like '% FONTANES%' OR
Results.Borrower Like '% FRANQUI%' OR
Results.Borrower Like '% FRESCO%' OR
Results.Borrower Like '% FUENTE%' OR
Results.Borrower Like '% FUENTES%' OR
Results.Borrower Like '% FURTADO%' OR
Results.Borrower Like '% G%' OR
Results.Borrower Like '% GAGINO%' OR
Results.Borrower Like '% GALAN%' OR
Results.Borrower Like '% GALEAS%' OR
Results.Borrower Like '% GALIANO%' OR
Results.Borrower Like '% GALINDEZ%' OR
Results.Borrower Like '% GALINDO%' OR
Results.Borrower Like '% GALLEGOS%' OR
Results.Borrower Like '% GALVAN%' OR
Results.Borrower Like '% GAMBAU%' OR
Results.Borrower Like '% GARAY%' OR
Results.Borrower Like '% GARCEZ%' OR
Results.Borrower Like '% GARCIA%' OR
Results.Borrower Like '% GARZA%' OR
Results.Borrower Like '% GASTELUM%' OR
Results.Borrower Like '% GAXIOLA%' OR
Results.Borrower Like '% GAYME(S)%' OR
Results.Borrower Like '% GAZTAMBIDE%' OR
Results.Borrower Like '% GENUNDEZ%' OR
Results.Borrower Like '% GERENA%' OR
Results.Borrower Like '% GINORIO%' OR
Results.Borrower Like '% GOMES%' OR
Results.Borrower Like '% GOMEZ%' OR
Results.Borrower Like '% GONGORA%' OR
Results.Borrower Like '% GONI%' OR
Results.Borrower Like '% GONSALES%' OR
Results.Borrower Like '% GONSALVES%' OR
Results.Borrower Like '% GONZALES%' OR
Results.Borrower Like '% GONZALEZ%' OR
Results.Borrower Like '% GRANADOS%' OR
Results.Borrower Like '% GRIEGO%' OR
Results.Borrower Like '% GUADALUPE%' OR
Results.Borrower Like '% GUERRA%' OR
Results.Borrower Like '% GUERRERO(A)%' OR
Results.Borrower Like '% GURREA%' OR
Results.Borrower Like '% GUTIERRES%' OR
Results.Borrower Like '% GUTIERREZ%' OR
Results.Borrower Like '% GUZMAN%' OR
Results.Borrower Like '% HABER%' OR
Results.Borrower Like '% HADDOCK%' OR
Results.Borrower Like '% HAMMEKEN%' OR
Results.Borrower Like '% HECTOR%' OR
Results.Borrower Like '% HERMIDA%' OR
Results.Borrower Like '% HERNANDES%' OR
Results.Borrower Like '% HERNANDEZ%' OR
Results.Borrower Like '% HERRERA%' OR
Results.Borrower Like '% HIGUERA%' OR
Results.Borrower Like '% HIGUERAS%' OR
Results.Borrower Like '% HOLGUIN%' OR
Results.Borrower Like '% HUERTA%' OR
Results.Borrower Like '% HUESCA%' OR
Results.Borrower Like '% HUEZO%' OR
Results.Borrower Like '% HURTADO%' OR
Results.Borrower Like '% JACINTO%' OR
Results.Borrower Like '% JAIME%' OR
Results.Borrower Like '% JAIME(S)%' OR
Results.Borrower Like '% JAIMES%' OR
Results.Borrower Like '% JAQUINDE%' OR
Results.Borrower Like '% JAYME(S)%' OR
Results.Borrower Like '% JIMENEZ%' OR
Results.Borrower Like '% JOE%' OR
Results.Borrower Like '% JORGE%' OR
Results.Borrower Like '% JUAREZ%' OR
Results.Borrower Like '% LAGARDA%' OR
Results.Borrower Like '% LARA%' OR
Results.Borrower Like '% LATORRE%' OR
Results.Borrower Like '% LAUREANO%' OR
Results.Borrower Like '% LAURENCO%' OR
Results.Borrower Like '% LAVANDERO%' OR
Results.Borrower Like '% LEAL%' OR
Results.Borrower Like '% LEBRON%' OR
Results.Borrower Like '% LED(O)UC%' OR
Results.Borrower Like '% LEDESMA%' OR
Results.Borrower Like '% LEDOUX%' OR
Results.Borrower Like '% LENERO%' OR
Results.Borrower Like '% LEON%' OR
Results.Borrower Like '% LERMA%' OR
Results.Borrower Like '% LEYBA%' OR
Results.Borrower Like '% LIENDO%' OR
Results.Borrower Like '% LIMA%' OR
Results.Borrower Like '% LIZANA%' OR
Results.Borrower Like '% LLAMAS%' OR
Results.Borrower Like '% LONGORIA%' OR
Results.Borrower Like '% LOPEZ%' OR
Results.Borrower Like '% LOZA%' OR
Results.Borrower Like '% LOZANO%' OR
Results.Borrower Like '% LUCAS%' OR
Results.Borrower Like '% LUCERO%' OR
Results.Borrower Like '% LUJAN%' OR
Results.Borrower Like '% MADRID%' OR
Results.Borrower Like '% MAESTAS%' OR
Results.Borrower Like '% MAEZ%' OR
Results.Borrower Like '% MAGANA%' OR
Results.Borrower Like '% MALDONADO%' OR
Results.Borrower Like '% MALTES%' OR
Results.Borrower Like '% MANGEL%' OR
Results.Borrower Like '% MANRESA%' OR
Results.Borrower Like '% MANZANERES%' OR
Results.Borrower Like '% MARCANO%' OR
Results.Borrower Like '% MARCHAND%' OR
Results.Borrower Like '% MARMOL%' OR
Results.Borrower Like '% MARQUEZ%' OR
Results.Borrower Like '% MARRERO%' OR
Results.Borrower Like '% MARTEL(L)%' OR
Results.Borrower Like '% MARTI%' OR
Results.Borrower Like '% MARTIN%' OR
Results.Borrower Like '% MARTINEZ%' OR
Results.Borrower Like '% MASFERRER%' OR
Results.Borrower Like '% MAT(T)OS%' OR
Results.Borrower Like '% MATEO%' OR
Results.Borrower Like '% MATOS%' OR
Results.Borrower Like '% MAULEN%' OR
Results.Borrower Like '% MEDINA%' OR
Results.Borrower Like '% MEDRANO%' OR
Results.Borrower Like '% MEJIAS%' OR
Results.Borrower Like '% MELENDEZ%' OR
Results.Borrower Like '% MELIANS%' OR
Results.Borrower Like '% MENA%' OR
Results.Borrower Like '% MENASCO%' OR
Results.Borrower Like '% MENCHACA%' OR
Results.Borrower Like '% MENDEZ%' OR
Results.Borrower Like '% MENDIVES%' OR
Results.Borrower Like '% MENDOZA%' OR
Results.Borrower Like '% MENENDEZ%' OR
Results.Borrower Like '% MENTOYA%' OR
Results.Borrower Like '% MERCADO%' OR
Results.Borrower Like '% MEZA%' OR
Results.Borrower Like '% MIGUEZ%' OR
Results.Borrower Like '% MIR%' OR
Results.Borrower Like '% MIRABAL%' OR
Results.Borrower Like '% MIRANDA%' OR
Results.Borrower Like '% MIRELES%' OR
Results.Borrower Like '% MOLDONADO%' OR
Results.Borrower Like '% MOLINA%' OR
Results.Borrower Like '% MOLINAR%' OR
Results.Borrower Like '% MONARRES%' OR
Results.Borrower Like '% MONESTEL%' OR
Results.Borrower Like '% MONGE%' OR
Results.Borrower Like '% MONTALVO%' OR
Results.Borrower Like '% MONTANEZ%' OR
Results.Borrower Like '% MONTEAGUDO%' OR
Results.Borrower Like '% MONTEMAYOR%' OR
Results.Borrower Like '% MONTERO%' OR
Results.Borrower Like '% MONTES%' OR
Results.Borrower Like '% MONTOLLA%' OR
Results.Borrower Like '% MONTOYA%' OR
Results.Borrower Like '% MORA%' OR
Results.Borrower Like '% MORAGA%' OR
Results.Borrower Like '% MORALES%' OR
Results.Borrower Like '% MOREIRA%' OR
Results.Borrower Like '% MOREL%' OR
Results.Borrower Like '% MORELES%' OR
Results.Borrower Like '% MORENO%' OR
Results.Borrower Like '% MORINGLANES%' OR
Results.Borrower Like '% MOSQUEDA%' OR
Results.Borrower Like '% MOSQUERA%' OR
Results.Borrower Like '% MUNGUIA%' OR
Results.Borrower Like '% MUNIZ%' OR
Results.Borrower Like '% MUNOZ%' OR
Results.Borrower Like '% MURILLO%' OR
Results.Borrower Like '% MUZQUIZ%' OR
Results.Borrower Like '% NAPOLES%' OR
Results.Borrower Like '% NARANJO%' OR
Results.Borrower Like '% NARRO%' OR
Results.Borrower Like '% NASSI%' OR
Results.Borrower Like '% NATAL%' OR
Results.Borrower Like '% NAVAR%' OR
Results.Borrower Like '% NAVARRO%' OR
Results.Borrower Like '% NEGRON%' OR
Results.Borrower Like '% NEIRA%' OR
Results.Borrower Like '% NIEGO%' OR
Results.Borrower Like '% NIEVES%' OR
Results.Borrower Like '% NOLLA%' OR
Results.Borrower Like '% NUNEZ%' OR
Results.Borrower Like '% OCASIO%' OR
Results.Borrower Like '% OCHOA%' OR
Results.Borrower Like '% OGAZON%' OR
Results.Borrower Like '% OJEDA%' OR
Results.Borrower Like '% OLIVAREZ%' OR
Results.Borrower Like '% OLIVERA%' OR
Results.Borrower Like '% OLMOS%' OR
Results.Borrower Like '% OLVEDA%' OR
Results.Borrower Like '% ORELLANA%' OR
Results.Borrower Like '% ORIA%' OR
Results.Borrower Like '% ORLANDO%' OR
Results.Borrower Like '% ORNELAS%' OR
Results.Borrower Like '% OROS(Z)CO%' OR
Results.Borrower Like '% ORTEGON%' OR
Results.Borrower Like '% ORTIS%' OR
Results.Borrower Like '% ORTIZ%' OR
Results.Borrower Like '% OSLAN%' OR
Results.Borrower Like '% P%' OR
Results.Borrower Like '% PABON%' OR
Results.Borrower Like '% PACHECO%' OR
Results.Borrower Like '% PADILLA%' OR
Results.Borrower Like '% PAESA%' OR
Results.Borrower Like '% PAGAN%' OR
Results.Borrower Like '% PALMA%' OR
Results.Borrower Like '% PAMIAS%' OR
Results.Borrower Like '% PANAIGUA%' OR
Results.Borrower Like '% PAPI%' OR
Results.Borrower Like '% PARADA%' OR
Results.Borrower Like '% PARAMO%' OR
Results.Borrower Like '% PAREDES%' OR
Results.Borrower Like '% PARILLA%' OR
Results.Borrower Like '% PASANDIN%' OR
Results.Borrower Like '% PASQUAL%' OR
Results.Borrower Like '% PATILLO%' OR
Results.Borrower Like '% PaVa%' OR
Results.Borrower Like '% PAZ%' OR
Results.Borrower Like '% PEDRERO%' OR
Results.Borrower Like '% PELI(N)%' OR
Results.Borrower Like '% PELLOT%' OR
Results.Borrower Like '% PELTRO%' OR
Results.Borrower Like '% PENA%' OR
Results.Borrower Like '% PENALVER%' OR
Results.Borrower Like '% PERALTA%' OR
Results.Borrower Like '% PEREA%' OR
Results.Borrower Like '% PEREIRA%' OR
Results.Borrower Like '% PEREZ%' OR
Results.Borrower Like '% PERILLAN%' OR
Results.Borrower Like '% PERPINAN%' OR
Results.Borrower Like '% PESCINA%' OR
Results.Borrower Like '% PINION%' OR
Results.Borrower Like '% PINZON%' OR
Results.Borrower Like '% PIOQUINTO%' OR
Results.Borrower Like '% PIZANA%' OR
Results.Borrower Like '% PLACENTIA%' OR
Results.Borrower Like '% POMBO%' OR
Results.Borrower Like '% PORTILLO%' OR
Results.Borrower Like '% PORTOCARRERO%' OR
Results.Borrower Like '% PRIETO%' OR
Results.Borrower Like '% PROVENCIO%' OR
Results.Borrower Like '% PUGA%' OR
Results.Borrower Like '% PUIG%' OR
Results.Borrower Like '% PUMARADA%' OR
Results.Borrower Like '% QUERPIS%' OR
Results.Borrower Like '% QUINONES%' OR
Results.Borrower Like '% QUINONEZ%' OR
Results.Borrower Like '% QUINTANA%' OR
Results.Borrower Like '% QUINTANILLA%' OR
Results.Borrower Like '% RABELO%' OR
Results.Borrower Like '% RAMBRO%' OR
Results.Borrower Like '% RAMIREZ%' OR
Results.Borrower Like '% RAMOS%' OR
Results.Borrower Like '% RATNER%' OR
Results.Borrower Like '% RAYAS%' OR
Results.Borrower Like '% REBEIRO%' OR
Results.Borrower Like '% REBOYRO%' OR
Results.Borrower Like '% REDONDO%' OR
Results.Borrower Like '% RENDON%' OR
Results.Borrower Like '% RENTA%' OR
Results.Borrower Like '% REYES%' OR
Results.Borrower Like '% RICO%' OR
Results.Borrower Like '% RIOJAS%' OR
Results.Borrower Like '% RIOS%' OR
Results.Borrower Like '% RIQUELME%' OR
Results.Borrower Like '% RIVERA%' OR
Results.Borrower Like '% RIVERO%' OR
Results.Borrower Like '% ROBLES%' OR
Results.Borrower Like '% ROCHA%' OR
Results.Borrower Like '% RODEO%' OR
Results.Borrower Like '% RODRIGUEZ%' OR
Results.Borrower Like '% ROERIDO%' OR
Results.Borrower Like '% ROIG%' OR
Results.Borrower Like '% ROMAN%' OR
Results.Borrower Like '% ROMBRO%' OR
Results.Borrower Like '% ROMERO%' OR
Results.Borrower Like '% RONDA%' OR
Results.Borrower Like '% ROQUIERO%' OR
Results.Borrower Like '% ROS%' OR
Results.Borrower Like '% ROSA%' OR
Results.Borrower Like '% ROSADO%' OR
Results.Borrower Like '% ROSALES%' OR
Results.Borrower Like '% ROSARIO%' OR
Results.Borrower Like '% ROSELLO%' OR
Results.Borrower Like '% ROSILLO%' OR
Results.Borrower Like '% RUANO%' OR
Results.Borrower Like '% RUCAVADO%' OR
Results.Borrower Like '% RUEDA%' OR
Results.Borrower Like '% RUIZ%' OR
Results.Borrower Like '% RUPERTO%' OR
Results.Borrower Like '% SABATER%' OR
Results.Borrower Like '% SAENZ%' OR
Results.Borrower Like '% SAEZ%' OR
Results.Borrower Like '% SAIS%' OR
Results.Borrower Like '% SALAIS%' OR
Results.Borrower Like '% SALAZAR%' OR
Results.Borrower Like '% SALICHS%' OR
Results.Borrower Like '% SALINAS%' OR
Results.Borrower Like '% SALOMON%' OR
Results.Borrower Like '% SAMANIEGO%' OR
Results.Borrower Like '% SAN%' OR
Results.Borrower Like '% SANABRIA%' OR
Results.Borrower Like '% SANCHEZ%' OR
Results.Borrower Like '% SANTA%' OR
Results.Borrower Like '% SANTIAGO%' OR
Results.Borrower Like '% SANTIESTEBAN%' OR
Results.Borrower Like '% SANTINI%' OR
Results.Borrower Like '% SANTOS%' OR
Results.Borrower Like '% SANTOYO%' OR
Results.Borrower Like '% SANZ%' OR
Results.Borrower Like '% SARACEN%' OR
Results.Borrower Like '% SARDINAS%' OR
Results.Borrower Like '% SEANEZ%' OR
Results.Borrower Like '% SEPOLIO%' OR
Results.Borrower Like '% SEPULVEDA%' OR
Results.Borrower Like '% SERENIL%' OR
Results.Borrower Like '% SERNA%' OR
Results.Borrower Like '% SERRANO%' OR
Results.Borrower Like '% SEVILLA%' OR
Results.Borrower Like '% SILVA%' OR
Results.Borrower Like '% SIMEON%' OR
Results.Borrower Like '% SMITH%' OR
Results.Borrower Like '% SOLACHE%' OR
Results.Borrower Like '% SOLTERO%' OR
Results.Borrower Like '% SOTERA%' OR
Results.Borrower Like '% SOTO%' OR
Results.Borrower Like '% SOTTO%' OR
Results.Borrower Like '% SOUFFRONT%' OR
Results.Borrower Like '% SUAREZ%' OR
Results.Borrower Like '% SURILLO%' OR
Results.Borrower Like '% T(H)OMAS%' OR
Results.Borrower Like '% TACORONTE%' OR
Results.Borrower Like '% TAMAYO%' OR
Results.Borrower Like '% TAMEZ%' OR
Results.Borrower Like '% TEE%' OR
Results.Borrower Like '% TEJADA%' OR
Results.Borrower Like '% TERLAJE%' OR
Results.Borrower Like '% TESORO%' OR
Results.Borrower Like '% TIE%' OR
Results.Borrower Like '% TIJERINA%' OR
Results.Borrower Like '% TIRADO%' OR
Results.Borrower Like '% TOBAJAS%' OR
Results.Borrower Like '% TOIMIL%' OR
Results.Borrower Like '% TORO%' OR
Results.Borrower Like '% TORRES%' OR
Results.Borrower Like '% TORREZ%' OR
Results.Borrower Like '% TOVAR%' OR
Results.Borrower Like '% TRAVESIER%' OR
Results.Borrower Like '% TRESSARIEU%' OR
Results.Borrower Like '% TREVINO%' OR
Results.Borrower Like '% TRUJILLO%' OR
Results.Borrower Like '% Tx%' OR
Results.Borrower Like '% UBEDA%' OR
Results.Borrower Like '% UMPIERE%' OR
Results.Borrower Like '% URREA%' OR
Results.Borrower Like '% URRUTIA%' OR
Results.Borrower Like '% URTADO%' OR
Results.Borrower Like '% USMC%' OR
Results.Borrower Like '% VALADEZ%' OR
Results.Borrower Like '% VALDES%' OR
Results.Borrower Like '% VALDEZ%' OR
Results.Borrower Like '% VALENCIA%' OR
Results.Borrower Like '% VALENSULA%' OR
Results.Borrower Like '% VALENTIN%' OR
Results.Borrower Like '% VALENZUELA%' OR
Results.Borrower Like '% VALERIO%' OR
Results.Borrower Like '% VALERO%' OR
Results.Borrower Like '% VALLE%' OR
Results.Borrower Like '% VARELA%' OR
Results.Borrower Like '% VARGAS%' OR
Results.Borrower Like '% VASQUEZ%' OR
Results.Borrower Like '% VAZQUEZ%' OR
Results.Borrower Like '% VEGA%' OR
Results.Borrower Like '% VELAZCO%' OR
Results.Borrower Like '% VELEZ%' OR
Results.Borrower Like '% VERDUGO%' OR
Results.Borrower Like '% VERGARA%' OR
Results.Borrower Like '% VERONA%' OR
Results.Borrower Like '% VIDAL%' OR
Results.Borrower Like '% VIEYRA%' OR
Results.Borrower Like '% VILLA%' OR
Results.Borrower Like '% VILLA(R)MARZO%' OR
Results.Borrower Like '% VILLACRES%' OR
Results.Borrower Like '% VILLAGRAN%' OR
Results.Borrower Like '% VILLALOBOS%' OR
Results.Borrower Like '% VILLALONGO%' OR
Results.Borrower Like '% VILLALPANDO%' OR
Results.Borrower Like '% VILLAMIL%' OR
Results.Borrower Like '% VILLAREAL%' OR
Results.Borrower Like '% VILLARREAL%' OR
Results.Borrower Like '% VILLARUELLE%' OR
Results.Borrower Like '% VILLASENOR%' OR
Results.Borrower Like '% VILLEGAS%' OR
Results.Borrower Like '% VINENT%' OR
Results.Borrower Like '% VIVONI%' OR
Results.Borrower Like '% VIZCARRA%' OR
Results.Borrower Like '% VIZCAYA%' OR
Results.Borrower Like '% YANEZ%' OR
Results.Borrower Like '% YBARBO%' OR
Results.Borrower Like '% ZABALA%' OR
Results.Borrower Like '% ZAMARONO%' OR
Results.Borrower Like '% ZAPATA%' OR
Results.Borrower Like '% ZAPIEN%' OR
Results.Borrower Like '% ZELAYA%' OR
Results.Borrower Like '% ZERTUCHE%' OR
Results.Borrower Like '% ZUNIGA%'

ORDER BY Results.LoanAmount, Results.DecisionFico;

humanpuck
Yak Posting Veteran

94 Posts

Posted - 2006-07-19 : 13:35:14

bleh...try putting an opening parenths at the begining of your first OR statement and a closing one at the end of your last or statement. I don't think it'll work though, I think you might need to break this up into a few seperate queries.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-19 : 14:01:09

mycotopian,

You need to rework your query. Even if you can get it to compile, it will take a long time to execute. How many different Results.Borrower are there? I see that you mention that you are going to add 600+ lines to the query, but I'd like to know how many possible Borrowers are there in the Results table.

Tara Kizer

mycotopian
Starting Member

5 Posts

Posted - 2006-07-19 : 14:01:12

Penenths didnt work. I guess I'm SOL

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-07-19 : 15:59:53

Put what you have in your like expressions, '% ABACHICHE%', in a table, and then use this in your query:

where 
	MyTable.MyColumn like LikeExpressionTable.LikeExpression

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources