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
