On 7/5/06, Roger <[EMAIL PROTECTED]> wrote:
I have a company name as follows:Chemistry & chemicals I have plenty of those in my database which come with ampersands, now when i do a query i get nothing. How best can i write the query using a string with an ampersand as part of it.
select * from mytable where company = 'Chemistry & chemicals' does not work?
