Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL to select left character if a number but not a lette
Message
From
08/02/2002 15:01:06
Max Sankar
Harrisonburg, Virginia, United States
 
 
To
08/02/2002 14:44:47
Zlatin Zlatev
Sofia, Bulgaria
General information
Forum:
Visual Basic
Category:
Coding, syntax & commands
Title:
Re: SQL to select left character if a number but not a lette
Miscellaneous
Thread ID:
00617582
Message ID:
00617643
Views:
19
Thanks Zlatin!

>Try this:


>SELECT '0' as F1 FROM Test where Left(F1,1)<'2' OR Left(F1,1)>'9'
UNION ALL
SELECT Left(F1,1) as F1 FROM Test where Left(F1,1)>='2' AND Left(F1,1)<='9'
Previous
Reply
Map
View

Click here to load this message in the networking platform