Equiv. of EMPTY() in SQL Server

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Equiv. of EMPTY() in SQL Server

Message

From

13/08/2007 08:21:45

Bhavbhuti Nathwani
Venus Software Operations
Rajkot, India

13/08/2007 08:13:53

Sergey Berezniker
New York, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Equiv. of EMPTY() in SQL Server

Environment versions

Visual FoxPro:

VFP 9 SP1

Database:

MS SQL Server

Miscellaneous

Thread ID:

01247781

Message ID:

01247784

Views:

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
___________________________________________

Map

View

Click here to load this message in the networking platform