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: Like value from other table

Re: Like value from other table

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Fri, 21 Sep 2007 23:53:53 -0000
Message-ID: <1190418833.693908.88340@r29g2000hsg.googlegroups.com>


On Sep 21, 5:57 pm, Tony B <anthonybro..._at_googlemail.com> wrote:
> Hi All
>
> I am new to oracle and am using 10G
>
> In Access I often used the "Like" statement to query Table 1 with a
> value from table 2 like this:
>
> SELECT tblcompany.IDcompany, tblcompany.Company, tblcompany.Pcode,
> tblseller.IDSeller, tblseller.SellerNAme
> FROM tblcompany, tblseller
> WHERE (((tblcompany.Pcode) Like [tblseller]![Pcode_1] & " *"));
>
> What is the correct syntax for doing this in Oracle.
>
> TIA
>
> Tony

Hi Tony,

The % is a wildcard in Oracle.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements003.htm#i11223

HTH, Steve Received on Fri Sep 21 2007 - 18:53:53 CDT

Original text of this message

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