Re: ALLTRIM( ) in SQL statement

"David" <David.Aman@xxxxxxxxx> wrote:

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.

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."

Six hours for S, six hours for Q, six hours for L, and six hours
for anything else that comes up. <BEG>

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
.

Relevant Pages

  • Re: ALLTRIM( ) in SQL statement
    ... Thanks, Anders. ... It makes me laught to think about a little ... book I bought several years ago: "Teach yourself SQL in 24 hours." ...
    (microsoft.public.fox.programmer.exchange)
  • Re: [PHP] People who bought this also bought (amazon style) functionality...logic problem
    ... joins users with products that they have bought. ... Looks like I will really have to brush up on my Sql, ... Do You Yahoo!? ... Mail has the best spam protection around ...
    (php.general)
  • Re: Ask for a query
    ... I want a query that let ... Customer_ID 1 bought for the first time in September 2003, ... How do I write that in SQL? ... MON CUSTID ...
    (comp.databases.oracle.server)
  • Re: Merging two sql databases
    ... is to insert data from sql I bought into sql which came ... ALTER TABLE table_name RENAME normal_database_name.table_name ... Do you mean that I supposed to install a database I bought than work on that? ...
    (alt.php)
  • Re: Merging two sql databases
    ... is to insert data from sql I bought into sql which came ... with a website's script. ... It is MySql database. ...
    (alt.php)