Just curious, Sergey do you know why CAST works where VAL does not? Specifically a string with "2E" in it? I understand why VFP sees it as scientific notation, but CAST does not...

lcvalue = "2E828"
lcvalue1 = "200"
? VAL(lcvalue)  && produces numeric overflow
? CAST(lcvalue as Int)  && returns 0
? VAL(lcvalue1)   && returns 200
? CAST(lcvalue1 as Int)  && returns 200
tclocation = "2E818 Main St"
? CAST(GETWORDNUM(tclocation,1) AS INT)
tclocation = "2010 N Main St"
? CAST(GETWORDNUM(tclocation,1) AS INT)

>>How do I convert character into integer? Please help. Thanks, Sam
>
>

>lcString = "12345"
>? CAST(lcString AS int)
>