One thing I did forget to mention though is that I could also have: 12ABC2000 15ABC2000 ano those should come up under ABC2000 as well...I know, weird.
On 10/10/05, Mike Appenzellar <[EMAIL PROTECTED]> wrote: > > I believe this may be a sql question... > I have the following items in my database > ABC20 > ABC2000-GB > ABC2000-HC > ABC2000-BC > etc... > I need to write a script or sql statement that will only pull the base > products? > > Ex: > ABC20 > ABC2000 > Was trying to do LIKE %% statements but obviously ABC2000 always comes up > when you look for ABC20...any ideas? > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
