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
Title:
Re: IN LIST for a Select SQL
Miscellaneous
Thread ID:
00433749
Message ID:
00433972
Views:
16
What about this?
substring(d.eono,1,1) between "0" and "9")


>>Will it work for the first character?
>>

>>>Is this better?
>>>
>>>where B.EONO LIKE '[0-9]%'
>>>
>

>Yes it will. Take a look at LIKE operator in SQL Server BOL.
Jean-René Roy President of http://www.softdesign.qc.ca/
President of http://www.DevTeach.com and http://www.SQLTeach.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform