query

[Mygurutech]

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 Convert..
but get now the error on RIGHT..
please advice what to do

kisoen

 

[bborissov]

Check CAST and CONVERT functions in BOL:

SELECT Left([CallID],3) AS CallType, 
       CAST(Right([CallID],Len([CallID])-3) as integer) AS [Number]
FROM Call
WHERE IsNumeric(Right([CallID],Len([CallID])-3))=1

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.