Select * from table where field begins with "S"

Article View: borland.public.vdbase.data.sql

Article #214

Back to borland.public.vdbase.data.sql Previous Next

#214

From: Bradner/Klein
Date: Sun, 10 Jan 1999 00:00

7 lines
758 bytes

Is it possible to use character wildcards in the selection criteria of an
SQL statement, or in some valid fashion implement the following query ...

select * from table where not field="S*" (ill-fated attempt, there at the
end, to use a wildcard)

Thanks as usual for advice.

Technical Details

Message-ID: <77b2j2$lt97@forums.borland.com>

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: ff5a1,250eb9ebb537b3e,start
X-Google-Attributes: gidff5a1,public
From: "Bradner/Klein" <zap.p1554@mail.aai.arco.com>
Subject: Select * from table where field begins with "S"
Date: 1999/01/10
Message-ID: <77b2j2$lt97@forums.borland.com>
X-Deja-AN: 430987828
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Newsgroups: borland.public.vdbase.data.sql