LIKE MATCH USING & as a character
From: JB <june.bracken_at_volvo.com>
Date: 13 May 2002 07:04:42 -0700
Message-ID: <757cee95.0205130604.b17c1e0_at_posting.google.com>
Date: 13 May 2002 07:04:42 -0700
Message-ID: <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
It comes back with this message from oracle.
SQL> /
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?
2* where name_text like 'MOM & POP%'
Enter value for pipe:
old 2: where company_name like 'MOM & POP%'
new 2: where company_name like 'MOM %'
Much appreciated for your assistance.
JB Received on Mon May 13 2002 - 16:04:42 CEST