strange sql command

hi folks

if i try to execute the following command oracle asks to enter the value for mid, since it obviously interpretes it as a keyword or built-in function:

select oid, pid, p2maincat from t_product where p2maincat = 'Equity Switzerland Small & mid Cap';

how to avoid this? i need to tell the database even more clearly that everything right from the = is one single string.

cheers, marcel Received on Thu Mar 22 2001 - 00:54:53 CST