🚀 go-pugleaf

1. You could change your server sort-order to case-insensitive. However,
this requires rebuilding the database and all the data within it. And you
can't use normal backup and restore.
Alternatively, you could convert both field name and constant to uppercase
- but that probably will negatively affect performance if an index could be
used.
2. Not unless you have an IDENTITY column (or similar) in the table.
Relational database tables are not supposed to be ordered in any way.
3. I would recommend SQL Server Books Online (comes with the setup CD), as
it has a decent search engine.

Regards, Roger.

Heinz A. Krebs Dipl.-Ing. <hkrebs@fbch.tuwien.ac.at> wrote in article
<344B1EAD.E25@fbch.tuwien.ac.at>...
> servas!
> 
> i have three small questions about sql-queries:
> 
> 1. how can i make a case-insensitive selection? if i make the following:
>      SELECT titel FROM database WHERE titel LIKE '%apple%' 
>    i don't get the entries with 'Apple', but i want them all!
> 
> 2. can i retrieve a record by his recordnumber like
>      SELECT titel, rezept FROM database WHERE recordnumber=4162
> 
> 3. where can i get a good explanation of SQL-statements on the web to
>    avoid further boring questions by me?  ;-)
> 
> 
> ciao
>   H.
> 
> ***********************************************************************
>                    KOS - Kochbuch Online System
> 
>   45000 Kochrezepte online  siehe unter http://www.styria.co.at/kos/
> ***********************************************************************
> Heinz A. Krebs Dipl.Ing.        voice:  43-1-4077234 or 43-1-58801-5011
> Vienna University               fax:                       43-1-4077235
>   of Technology                 email:         hkrebs@fbch.tuwien.ac.at
> Institute of Organic Chemistry  WWW: http://info.tuwien.ac.at/
>   Department Naturstoffsynthese                      orgchem/krebs/
> Getreidemarkt 9/9/154           fido:                          2:310/67
> A - 1060 Wien                   mailbox:                   43-1-4077235
> ***********************************************************************
>