Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL equivalent to VAL not working
Message
De
13/08/2006 17:58:20
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01144926
Message ID:
01145152
Vues:
23
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"
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform