>I need to figure out what are the limitations in creating COM in VFP. Can we do SELECT commands in COM? Or limited only to setting and defining business logics with return values?
>
>Please guide me as we are moving into a C/S applications...

Tables opened by a COM server are not visible from the calling program (client). So you can SELECT, SEEK, whatever- but none of it matters- the only thing that the client will see is the returned values.