>>>Select f1,f2,00000 as n(5,0) as rownumber from MyTable Into Cursor dummy readwrite
>>>
>>>Show me an error: Command contains unrecognized phrase-keyword.
>>
>>Sorry. Got too used to CAST() syntax.
>>
>>As Borislav and Terry said, it should be:
>>

>>Select f1,f2,00000 as n(5,0) as rownumber from MyTable Into Cursor dummy readwrite
>>

>
>No we didn't! You've just repeated exactly the same! :-)

AARRGH. Somebody was talking to me (at work) when I was doing it. I pressed [ENTER] too early! Thx.