Seelct * from Mytable where MyField = ''

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Seelct * from Mytable where MyField = ''

Message

From

25/09/2013 18:23:48

Gerard O'Carroll
Kernel Software Ltd.
Dublin, Ireland

All

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

Seelct * from Mytable where MyField = ''

Environment versions

Visual FoxPro:

VFP 9 SP2

OS:

Windows Server 2012

Network:

Windows 2008 Server

Database:

MS SQL Server

Application:

Web

Miscellaneous

Thread ID:

01584133

Message ID:

01584133

Views:

Hi
Why does the following select ALL rows ?
Select * from MyTable where MyField = '' && Two single quotes without a space in between

Does not matter whether Set exact is on ot off
Tia
Gerard

Map

View

Click here to load this message in the networking platform