Re: Underscore "_" character problem

From: Luis <ltemes_at_usa.net>
Date: Tue, 30 May 2000 13:39:19 +0200
Message-Id: <10514.107250@fatcity.com>

Hi,
you can use translate
select product_code from table where translate(product_code,"_","#") like '728#%''

hth, Luis temes

drichard_at_mtlindia.com wrote:

> Dear Experts
>
> I have found a problem in my query.
>
> In the Product master, we have products like '728_', '728+', 'IMB7+',
> 'IMB7_'
>
> when we retrieve all the records using 'product_code like 'IMB7_',
> it retrieves the records belonging to 'IMB7_' alone.
>
> 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.
>
> any solution please.........
Received on Tue May 30 2000 - 06:39:19 CDT