I am trying to get this to run in Crystal Reports 2008, but it is not liking the parameters. Any help would be greatly appeciated.
SELECT (lnme||', '||fname||' '||mname) AS Name
FROM humrec2.emprofile
WHERE ({?RTYPE} = 'BDAY' OR {?RTYPE} = 'HireDate')