SQL to select left character if a number but not a lette

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

SQL to select left character if a number but not a lette

Message

08/02/2002 14:44:47

Zlatin Zlatev
Sofia, Bulgarie

08/02/2002 13:49:21

Max Sankar
Harrisonburg, Virginie, États-Unis

Information générale

Forum:

Visual Basic

Catégorie:

Codage, syntaxe et commandes

Titre:

Re: SQL to select left character if a number but not a lette

Divers

Thread ID:

00617582

Message ID:

00617631

Vues:

This message has been marked as the solution to the initial question of the thread.

Try this:

SELECT '0' as F1 FROM Test where Left(F1,1)<'2' OR Left(F1,1)>'9'
UNION ALL
SELECT Left(F1,1) as F1 FROM Test where Left(F1,1)>='2' AND Left(F1,1)<='9'

Zlatin Zlatev,
MCSD (VS6)

Make solutions, not programs!

Répondre

Fil

Voir

Click here to load this message in the networking platform