Re: Parameter Queries in Oracle?

From: <david.archer_at_chase.com>
Date: Fri, 27 Aug 1999 17:06:13 GMT
Message-ID: <7q6ghu$r1t$1@nnrp1.deja.com>

Try using LIKE ...

Example:

SELECT *
FROM Places
WHERE placetype LIKE [parPlaceType]||'%'

Good luck,

David Archer

In article <7q47uf$9bh$1_at_news.kabelfoon.nl>, "Edgar Walther" <waltheed_at_iquip.nl> wrote:
> Hi y'all,
>
> I am making queries and views on an Oracle database from MS Access. I
now
> try to make something like, what is called in Access terms, a
parameter
> query. It looks like this:
>
> Select *
> From Places
> Where PlaceType = [parPlaceType]
>
> I want to be able to set this parameter from Access.
> I also want to ignore this parameter if it is not filled.
>
> Does anyone know how to do (something like) this?
>
> I'd really appreciate some help!
>
> TIA,
>
> Edgar Walther
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 27 1999 - 12:06:13 CDT