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:28:03
Max Sankar
Harrisonburg, Virginia, United States
 
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:
00617617
Views:
18
Thanks Velina but it's still giving the '#Error' as a result. I'm using Microsoft Access queries to test it. Anything else that I could try?
Thanks
Max

>if this is run against native FoxPro table you can use VAL function:
>iif(val(left([myField],1))>2,....
Previous
Reply
Map
View

Click here to load this message in the networking platform