(Q): SQL-Queries

Article View: comp.lang.pascal.delphi.databases

Article #171

Back to comp.lang.pascal.delphi.databases Previous Next

#171

From: Heinz A. Krebs Dipl.-Ing.
Date: Mon, 20 Oct 1997 00:00

32 lines
2013 bytes

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
***********************************************************************

Technical Details

Message-ID: <344B1EAD.E25@fbch.tuwien.ac.at>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,c6b02df51994e2b0,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10de66,c6b02df51994e2b0,start
X-Google-Attributes: gid10de66,public
X-Google-Thread: 11301e,c6b02df51994e2b0,start
X-Google-Attributes: gid11301e,public
From: "Heinz A. Krebs Dipl.-Ing." <hkrebs@fbch.tuwien.ac.at>
Subject: (Q): SQL-Queries
Date: 1997/10/20
Message-ID: <344B1EAD.E25@fbch.tuwien.ac.at>
X-Deja-AN: 281935710
Organization: TU Vienna - Dept. Organic Chemistry
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.sqlservers,microsoft.public.sqlserver.programming