George, I just rebuilt the indices on the CLINE table, then tried the LIKE using the '...' as a wildcard, so I tried:
SELECT CLIENT WITH NAME LIKE "BRUCE..." and unfortunately that worked the exact same way as the [] wildcards, returning 1 result. The approach I'm going to use is the one you suggested (to create an I-descriptor to do an UPCASE(NAME) ) and then index that. The only part I'm not sure about is since this descriptor is using the field NAME, should I also index NAME? I've indexed NAME already and seems to be working great, just not sure if indexing NAME should be done for performance. Chris > From: [email protected] > To: [email protected] > Date: Tue, 26 Jul 2011 14:27:58 -0500 > Subject: Re: [U2] CONV MCU on indexed field? > > I think your running in PICK mode, and I know that LIKE works in PICK flavor > as well. > > LIKE is the equivilent to [ and ] > > SELECT FILE WITH NAME = "[TEST" > SELECT FILE WITH NAME LIKE "...TEST" > > SELECT FILE WITH NAME = "TEST]" > SELECT FILE WITH NAME LIKE "TEST..." > > SELECT FILE WITH NAME = "[TEST]" > SELECT FILE WITH NAME LIKE "...TEST..." > > REPLACE THE [ OR ] WITH ... > AND REPLACE THE = WITH LIKE > > George _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
