Special characters once again !

[guess who]

I told that i want to insert the following....
where part_no='1234' and name='guest'

but i tried as u people said  ( ' Where part_no="1234" and name="guest" ' ) but the 
result was, which is as follows....
where part_no="1234" and name="guest"
but what i need is as follows...
where part_no='1234' and name='guest'
Regards,
Prakash.