SQL select brings record over even when not match

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SQL select brings record over even when not match

Message

From

16/09/2005 16:31:59

Beth Walsh
Walsh & Company
Montana, United States

16/09/2005 15:16:46

Edgar Bolton
Madison, Tennessee, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: SQL select brings record over even when not match

Environment versions

Visual FoxPro:

VFP 6 SP5

OS:

Windows 2000 SP4

Database:

Visual FoxPro

Miscellaneous

Thread ID:

01049862

Message ID:

01050494

Views:

Sergey, Cetin and Peter helped me figure this out. It was Nulls in the field causing the problem.
Now Fixed.

Thanks anyway.
beth
>try ... Upper(stu.enrollment_status) <> 'INACTIVE' ...
>

Map

View

Click here to load this message in the networking platform