sql ampersand error
796627Sep 8 2010 — edited Sep 8 2010Hi All,
I have 2 tables:
Table name: A
Fieldname: X
Field value: 'test&test'
Table name: B
Fieldname: Z
Field value: 'test&test'
I have a clause where
select X from A;
fetch X into Y;
select Z from B where Z=Y.
I am getting an error like they are asking the value of test.
What is the work around of this?