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
