Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Very Complex SQL - My Brain Hurts
Message
From
07/07/2006 14:04:44
Sergey Berezniker
New York, United States
 
 
To
07/07/2006 13:40:32
Terry McDonnell
Brighton, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Very Complex SQL - My Brain Hurts
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01133780
Message ID:
01134543
Views:
19
<snip>
>>
  • Avoid using ALLTRIM() in queries.
    >
    >OK. But I assumed that they might be different sizes and would need to trim them both to ensure equality.
    >

    That's why I replaced "=" with "==". Check SET ANSI for more details.
    --sb--
    • Previous
    Reply
    Map
    View

    Click here to load this message in the networking platform