PRB:Using fieldname+1 in SELECT statement

[Ian]

Hi there,   Just converted an SQL server DB over to SAP DB and things are looking really good now, I expected I would need to ensure all my querys from my program work and expected to have to update a few – anyway I got problems with this one which is really trivial…   SELECT  UserID, Extension, Type, Hookstate, '<ACD CALL>0' AS ACDcall, Data + 1 AS Data FROM Extension WHERE Data ='3'   It works in SQL Server and MySQL .. it seems it doesn’t like the data+1. If I remove the +1 then it works.. I tried surrounding it with brackets but it still doesn’t work   Any ideas???   Thanks in advance for any help   Ian This email has been scanned for viruses and found to be clean. I can be contacted via MSN Messenger using [EMAIL PROTECTED] as the signin name. Why not use it!?