hi,
i'm building an application with sql server iso Access
now when converting the access query into sql server
retrieving an error
SELECT Left([CallID],3) AS CallType, Val(Right([CallID],Len([CallID])-3)) AS [Number]
FROM Call
WHERE (((IsNumeric(Right([CallID],5)))=True));
VAL should be...