Verifying two SQL commands

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Verifying two SQL commands

Message

20/02/2008 15:42:45

Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada

20/02/2008 15:40:08

Sergey Berezniker
New York, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Verifying two SQL commands

Versions des environnements

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Database:

Visual FoxPro

Divers

Thread ID:

01294455

Message ID:

01294463

Vues:

>Try

>SELECT * From MyTable WHERE LEN(RTRIM(MyField))>0
>

Is this supported as is in SQL Server?

Also, if it is, then the minor difference with mine would only be to use RTRIM instead of ALLTRIM. Could you elaborate on that topic as to know why you suggest RTRIM? Is it because it is supported in SQL Server as well?

Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52

Répondre

Fil

Voir

Click here to load this message in the networking platform