Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL equivalent to VAL not working
Message
From
13/08/2006 17:58:20
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01144926
Message ID:
01145152
Views:
18
Most are:
101
211
1001
3001

but some are:
101B
201C
3505B
33-1

Hard to work with when you want to grab a range from 100-300...


>Ah yes, I see. Is it at most one letter at the end or can it be more? And can letters exist in other places in the field?
>
>Chad
>
>
>>Some results that should not be included were returned:
>>
>>111
>>21
>>217
>>210
>>...
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Reply
Map
View

Click here to load this message in the networking platform