Hello all!

Im wrote a query

UPDATE otest SET otest.id=dup.id;
WHERE;
otest.bdate=dup.bdate;
AND;
otest.fname=dup.fname

but ive noticed this query doesnt work when i leave in the Fname which is a character but it queries fien using the date only, the Fname is a character. Can i not do that with a charactER?