Re: LIKE MATCH USING & as a character

Hello,

Could you please try the following ;
select * from name
where company_name like ('MOM'||' & '||'POP%');

Regards
Bhooshan

june.bracken_at_volvo.com (JB) wrote in message news:<757cee95.0205130604.b17c1e0_at_posting.google.com>...
> I need help. I have looked everywhere for an example of how to do
> this correctly. I understand of how to use escaping to use the % or _
> as a character. What I have not found is how to use it on the
> ampersand character. Here is the example of I have.
>
> 1 select * from name
> 2* where name_text like 'MOM & POP%'
>
> It comes back with this message from oracle.
>
> SQL> /
> Enter value for pipe:
> old 2: where company_name like 'MOM & POP%'
> new 2: where company_name like 'MOM %'
>
> This returns all the MOM names instead of just the MOM & POP's. I
> need this for some search criteria. Is there anyway of making the
> ampersand a character?
>
> Much appreciated for your assistance.
>
> JB
Received on Tue May 14 2002 - 06:40:29 CEST