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 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:
00617631
Views:
23
This message has been marked as the solution to the initial question of the thread.
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'
Zlatin Zlatev,
MCSD (VS6)

Make solutions, not programs!

Previous
Next
Reply
Map
View

Click here to load this message in the networking platform