Hi Like will work to a point, but in this case it will only grab with matt. You could try something along the lines of
select * from my_tab where left$(col1, 4) = left$(col2, 4) Also remember that the comparison is case insensitive Regards Simon Roy wrote: > > I use the "like" statement. > > select my_table where my_column like "matt%" > > ----- Original Message ----- > From: "Adam Serafin" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, January 28, 2003 1:26 PM > Subject: MI-L partial duplicates > > > Hello list, > > > > I need some help with a query. I would like to select out records from > one > > column where the first 4 characters in the column match one another. For > > example, in a column "names", I would like the query to select out "matt" > as > > well as "matthew". I think it can be accomplished with some incarnation > of > > LEFT$(names, 4), however, I haven't been able to figure it out. > > > > Thanks in Advance, > > > > Adam J. Serafin > > Cartographer > > ENERmap Inc. > > [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > List hosting provided by Directions Magazine | www.directionsmag.com | > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > Message number: 5181 > > > > > > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 5183 -- Mike Taylor ______________________________________________ GIS Senior Consultant mailto:[EMAIL PROTECTED] Sinclair Knight Merz Limited http:\\www.skmconsulting.com Level 12, Mayfair House Tel: +64 4 473 4265 54 The Terrace Fax: +64 4 473 3369 PO Box 10283,Wellington New Zealand NOTICE: This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action in reliance on it. If you have received this message in error please notify Sinclair Knight Merz Ltd immediately. Any views expressed in this message are those of the individual sender, except where the sender has the authority to issue and specifically states them to be the views of Sinclair Knight Merz. The recipient is responsible for reviewing the status of the transferred information and should advise Sinclair Knight Merz immediately upon receipt of any discrepancy. The sender makes no warranty regarding the presence of electronic or magnetic data errors or computer viruses, or as to the accuracy or completeness of the data transmitted. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5184
