Perhaps... Where Right([OrderNumber],1) not like '[A-Z]' On Mon, Aug 8, 2011 at 8:23 AM, Sean Rector <[email protected]> wrote: > Guys, > > > > I have a quick question on how I can construct a SQL SELECT WHERE clause > that uses NOT LIKE and won’t select any entry that ends with a capital > letter. > > > > I’ve tried > > > > WHERE OrderNumber not like '%[A-Z]%' > > > > But that isn’t working for me. > > > > Sean Rector, MCSE > > > > Information Technology Manager > Virginia Opera Association > > E-Mail: [email protected] > Phone: (757) 213-4548 (direct line) > {+} > > Tickets and Subscriptions On Sale Now! > Aida | Hansel And Gretel | Orphée | The Mikado > Visit us online at www.VaOpera.org or call 1-866-OPERA-VA > > Experience the Beauty, Power & Passion of Virginia Opera. > > ________________________________ > > This e-mail and any attached files are confidential and intended solely for > the intended recipient(s). Unless otherwise specified, persons unnamed as > recipients may not read, distribute, copy or alter this e-mail. Any views or > opinions expressed in this e-mail belong to the author and may not > necessarily represent those of Virginia Opera. Although precautions have > been taken to ensure no viruses are present, Virginia Opera cannot accept > responsibility for any loss or damage that may arise from the use of this > e-mail or attachments. > > {*} > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin
-- -- Michael S. White [email protected] ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
