Why doesn't this SQL Select return the expected answer

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Why doesn't this SQL Select return the expected answer

Message

From

03/07/2000 08:48:32

Richard Liebespach
The Omnia Group Inc.
Tampa, Florida, United States

29/06/2000 20:27:48

Sergey Berezniker
New York, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Why doesn't this SQL Select return the expected answer

Miscellaneous

Thread ID:

00386612

Message ID:

00387708

Views:

Sergey,
You're the greatest!!!
Thank you for saving my sanity!
I'll go check this now.

...I just checked it and yes ansi is off!
You're the man!!!

Thank you!
Rick

---------------------------------
>Rick,
>
>MS KB article Q142887 states that "Using an ALLTRIM() function with an SELECT-SQL statement when SET ANSI OFF may result in the return of an incorrect subset of records."
>
>
>

Map

View

Click here to load this message in the networking platform