Re: ALLTRIM( ) in SQL statement

From: "David" <David.Aman@xxxxxxxxx>
Date: 13 Mar 2007 11:05:38 -0700

On Mar 12, 4:33 pm, "Anders Altberg" <anders.altberg> wrote:

Alltrim " " equals the empty string which in the logic of SQL is equal to
any value.
-Anders

Thanks, Anders. This is something that I did not know before you and
Bernhard explained it. It makes me laught to think about a little
book I bought several years ago: "Teach yourself SQL in 24 hours."

David

.

Follow-Ups:
- Re: ALLTRIM( ) in SQL statement
  - From: Gene Wirchenko

References:
- ALLTRIM( ) in SQL statement
  - From: David
- Re: ALLTRIM( ) in SQL statement
  - From: Gene Wirchenko
- Re: ALLTRIM( ) in SQL statement
  - From: David
- Re: ALLTRIM( ) in SQL statement
  - From: Anders Altberg

Prev by Date: Re: ALLTRIM( ) in SQL statement
Next by Date: mouseleave doesn't always fire
Previous by thread: Re: ALLTRIM( ) in SQL statement
Next by thread: Re: ALLTRIM( ) in SQL statement
Index(es):
- Date
- Thread

Relevant Pages

Re: ALLTRIM( ) in SQL statement
... It makes me laught to think about a little ... book I bought several years ago: "Teach yourself SQL in 24 hours." ... He/She has prejudices. ...
(microsoft.public.fox.programmer.exchange)
RE: SV: SV: if seek() assistance
... Here you go anders, i would rather talk in an email than here. ... use c:\testdata\combdet.dbf in 0 shared Alias combdet order key ... > You're still not sold on SQL? ... >>> When you're the the column references in lkey don't have an alias reference. ...
(microsoft.public.fox.programmer.exchange)
Re: Why comes such error?
... > Hi Anders, ... 1808: SQL: ORDER BY clause is invalid.). ... > Bye, Olaf. ...
(microsoft.public.fox.programmer.exchange)
Re: SQL --> SetRange
... SQL, my mistake. ... Anders ... Prev by Date: ...
(comp.databases.paradox)