MySQL Query Syntax vs MSSQL

[DWolff]

We just converted a database from MySQL 4.1.20 to 5.0 so we can create a view that we may query against. We'd like to use a previous MS Access Query (i.e. MS SQL) to create the View, but are running into syntax errors. I think we've discovered that IIF statements become IF statements, but there are other issues as well. Here is the Access Query. I believe that we also have a problem in the area of "InStr" where we are searching for the character "<" or ">".

SELECT cdr.calldate AS [Date], cdr.calldate AS [time], IIf(Len([src])=3,"O","I") AS inout, IIf([inout]="O",[Src],[Dst]) AS Station, IIf([inout]="O",[dst],[src]) AS LDN, Mid([clid],2,InStr(3,[clid],"<")-4) AS CallerName, Mid([clid],InStr([clid],"<")+1,[numdig]) AS CallerNum, cdr.duration, cdr.billsec, IIf([channel] Like "zap*",[channel],[dstchannel]) AS trunk, cdr.dcontext, InStr([clid],">")-InStr([clid],"<")-1 AS numdig, cdr.clid
FROM cdr
WHERE (((cdr.billsec)>45) AND ((Left([channel],3) & Left([dstchannel],3)) In ("zapsip","sipzap")) AND ((cdr.disposition)="answered")); 

Any help would be greatly apprciated.