RE: Underscor "_" character problem

From: Miguel Urosa <murosa_at_smseuropa.com>
Date: Wed, 31 May 2000 13:03:25 +0200
Message-Id: <10514.107239@fatcity.com>

        That's because '_' for SQL*PLUS is a joker character, and it's substitute it by any other character. Maybe you must indicate an escape character before '_' to indicate that it parse like that character.

        HTH
> -----Mensaje original-----
> De: drichard_at_mtlindia.com [SMTP:drichard_at_mtlindia.com]
> Enviado el: mi=E9rcoles 31 de mayo de 2000 11:18
> Para: Multiple recipients of list ORACLE-L
> Asunto: Underscor "_" character problem

>=20
>=20
>=20

> Dear Experts

>=20

> I have found a problem in my query.

>=20

> In the Product master, we have products like '728_', '728+',
> 'IMB7+',
> 'IMB7_'

>=20


> when we retrieve all the records using  'product_code like 'IMB7_',

>      it retrieves the records belonging to  'IMB7_'    alone.

>=20

> But when we retrieve all the records using 'product_code like =
'728_',
> it retrieves the records belonging to '728_' and '728+'.
> It is not recognising the "_" character when included with numbers.

>=20

> any solution please.........

>=20

> thanks

>=20
>=20

> --=20
> Author:=20
> INET: drichard_at_mtlindia.com

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed May 31 2000 - 06:03:25 CDT