Hi , I am new to t-sql so bear with me cos this might be a stupid question.
The code below
SELECT [CODE], [PERIOD], [OPERATOR], [RATE], Round(IIF([OPERATOR]='/',[RATE],1/[RATE]),3) AS EXCHRATE
WHERE [CODE]='NGN' AND [PERIOD]<>0
always gives me the following error message
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '='.
However when i remove the round() code from the statement it executes fine.
Can someone please please let me know what I am doing wrong here....