Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IN LIST for a Select SQL
Message
 
 
À
25/10/2000 08:50:29
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00433749
Message ID:
00433974
Vues:
21
>Doesn't this match any word that begins with a zero through nine?
>
>Try this in the QA:
>
>if '123' like '[0-9]%' print 'match'
>
>You could take the best of both queries:
>
>substring(e.eono,1,1) LIKE '[0-9]'
>
>-Mike


Yes it does. That's what it suppouse to do.
The same is true about your code substring(e.eono,1,1) LIKE '[0-9]'
What's your point?
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform