>Hi all again,
> Is it possible to create a cursor or local view using SQL? If there is, what's the syntax? I'd be glad to hear from you guys. Sorry for these "easy" questions ...... they are so hard for me coz I'm new in VFP 6. :-)

In addition to Hector's and Alexander's answers, you can use standard ANSI SQL SELECT syntax to create a cursor as a result set.

SELECT ...
   INTO CURSOR curTemp

CREATE CURSOR curTemp ;
   (field1 L)

I like easy questions. I can answer those.