You probably aren't using a case sensitive collation anyway...
One option is to go caveman style on it with ASCII(RIGHT(somefield,1))
NOT BETWEEN ASCII('A') AND ASCII('Z')
--Steve
On Mon, Aug 8, 2011 at 11:37 AM, Sean Rector <[email protected]> wrote:
> Tried that – it didn’t work either.
>
>
>
> Sean Rector, MCSE
>
>
>
> From: Spencer Read [mailto:[email protected]]
> Sent: Monday, August 08, 2011 11:30 AM
>
> To: NT System Admin Issues
> Subject: RE: Quick SQL Like statement question
>
>
>
> Take the last % sign out of the query?
>
> WHERE OrderNumber not like '%[A-Z]'
>
>
>
> …Spence
>
>
>
>
>
> From: Sean Rector [mailto:[email protected]]
> Sent: 08 August 2011 16:24
> To: NT System Admin Issues
> Subject: Quick SQL Like statement question
>
>
>
> 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.
>
>
~ 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
