Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IN LIST for a Select SQL
Message
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00433749
Message ID:
00433974
Views:
20
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform