Re: SQL Best Book for Writing SQL queries

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

Article #1284

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

#1284

From: Ken Mayer
Date: Fri, 13 Feb 1998 00:00

14 lines
1004 bytes

Timothy Tucker wrote:
> by the way can you do test with SQL that search strings for certain
> characters?  Example:
> 
>         "it" is in "City"

select * from tablename where fieldname like '%it%'

(substitute tablename and fieldname for the real thing)

-- 
Ken[1]@Borland
<Please follow-up to newsgroup; do not reply to email>

Technical Details

Message-ID: <34E46CAC.65B7@borland.com>

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

References:

<34E29804.4A55@enol.com> <34E324C3.1E27@borland.com> <34E36434.E51A2ACD@enol.com> <34E3652D.679B@borland.com> <34E3C9DC.F85@enol.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,627ce3f059bcf13a
X-Google-Attributes: gidff5a1,public
From: Ken Mayer <supportinfo@borland.com>
Subject: Re: SQL Best Book for Writing SQL queries
Date: 1998/02/13
Message-ID: <34E46CAC.65B7@borland.com>
X-Deja-AN: 324780311
Content-Transfer-Encoding: 7bit
References: <34E29804.4A55@enol.com> <34E324C3.1E27@borland.com> <34E36434.E51A2ACD@enol.com> <34E3652D.679B@borland.com> <34E3C9DC.F85@enol.com>
Content-Type: text/plain; charset=us-ascii
Organization: Borland, International
Mime-Version: 1.0
Reply-To: supportinfo@borland.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message