Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: quick SQL question
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
![]() |
![]() |