LIKE MATCH USING & as a character

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 Mon May 13 2002 - 16:04:42 CEST