February 21, 2012, 06:26 AM
mark66[SOLVED]Selecting on a value that contains "&"
Hi all,
I need to setup a report version for a field whose value actually contains "&"…
Eg:
TABLE FILE TEST
PRINT *
WHERE FIELDA EQ 'AA&BB';
END
-RUN
Program fails with:
(FOC295) A VALUE IS MISSING FOR: &BB
I have tried putting the value into a &var, and using EVAL, but it still fails.
Is there a way to ignore the &er for this line of code?
Thanks
Mark
This message has been edited. Last edited by: mark66, February 21, 2012, 07:05 AM
Danny-SRL
-* File mark66_2.fex
TABLE FILE CAR
PRINT COUNTRY
IF COUNTRY EQ 'AA&|BB'
END
February 21, 2012, 07:12 AM
mark66Awesome, works great.
Thanks Danny!