Re: quick SQL question

select count(*) from <table>
where upper(future_plans) like upper('%military%')

Homework, full table scan

Hth,

Sybrand Bakker, Oracle DBA

John Andersen <john_at_sd6.k12.mt.us.com (remove .com)> schreef in berichtnieuws 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