Equiv. of EMPTY() in SQL Server

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Equiv. of EMPTY() in SQL Server

Message

13/08/2007 08:21:45

Bhavbhuti Nathwani
Venus Software Operations
Rajkot, Inde

13/08/2007 08:13:53

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: Equiv. of EMPTY() in SQL Server

Versions des environnements

Visual FoxPro:

VFP 9 SP1

Database:

MS SQL Server

Divers

Thread ID:

01247781

Message ID:

01247784

Vues:

Hi Sergey

>There's no similar function in MS SQL Server. To check if strings is empty or has only spaces

>LEN(StrCol) = 0
>

Thanks. This will do the job for me.

Can I update the Fox Wiki's page naming you with the above suggestion http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping~VFP ?

Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________

Répondre

Fil

Voir

Click here to load this message in the networking platform