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:28:03

Max Sankar
Harrisonburg, Virginie, États-Unis

08/02/2002 14:02:44

Venelina Jordanova
Outsourcing I T Services Ltd.
Varna, Bulgarie

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:

00617617

Vues:

Thanks Velina but it's still giving the '#Error' as a result. I'm using Microsoft Access queries to test it. Anything else that I could try?
Thanks
Max

>if this is run against native FoxPro table you can use VAL function:
>iif(val(left([myField],1))>2,....

Répondre

Fil

Voir

Click here to load this message in the networking platform