Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: quick SQL question

Re: quick SQL question

From: Gavin McCarter <gavin.mccarter_at_@@pss.boeing.com>
Date: 2000/05/05
Message-ID: <Fu3HF3.Guv@news.boeing.com>#1/1

select count(*) from your_table_name where future_plans like '%Military%';

Note that this is case sensitive. I would recommend:

select count(*) from your_table_name where upper(future_plans) like '%MILITARY%'; "John Andersen" <john_at_sd6.k12.mt.us.com (remove .com)> wrote in message news:8eukct$gaq$1_at_hydra.bigsky.net...
> Hello all,
>
> I am assisting a coworker, and could use a quick response to the
 following:
>
> what would the SQL command be that would list the number of reconds that
> contain a given word (Military) in a given field (future_plans)
> In other words how many records contain the word "military" in the field
> "future_plans"
>
> thanks!
>
>
Received on Fri May 05 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US