Hi all,
Bit of SQL help here, i'm really stuck been working on this for a couple hours. No idea why i'm getting an error whenever I run this SQL query, using a text driver through an ODBC connection to query a csv file...
Can anyone see anything wrong with my sql?
select payee.*,
payee.AHIRDA+'/'+payee.AHIRMO+'/'+payee.AHIRYR AS Date_Of_Hire,
CASE ATRMDA
WHEN 0 THEN '31/12/2999'
ELSE payee.ATRMDA+'/'+payee.ATRMMO+'/'+ payee.ATRMYR
END AS Termination_Date
from
ptaagr0999.csv payee
Any help much appreciated.
I keep getting hte following error:
Syntax error(Missing operator) in query expression
'CASE ATRMDA
WHEN 0 THEN '31/12/2999'
ELSE payee.ATRMDA+'/'+payee.ATRMMO+'/'+ payee.ATRMYR
END'
Thanks a lot..