IN LIST for a Select SQL

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

IN LIST for a Select SQL

Message

25/10/2000 09:03:50

25/10/2000 08:16:56

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Divers

Thread ID:

00433749

Message ID:

00433972

Vues:

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