Stored Procedures can be precompiled, so they should run a tad bit faster.

>I have a lot of queries that are built inside the vfp front end, very simple example here with how I call it:
>
>

>lcLastName='KELLY'
>text to lcCmd noshow
>    select lastname, firstname, mi from coPatients where isactive=1
>      where lastname=?lcLastName
>endtext
>
>if sqlexec(gnConnHandle,lcCmd,"CurPatLookUp")<1
>   =sqlerror()
>else
>   ...code here
>endif
>

>
>is there a performance difference if I make all my queries StoredProcedures vice just calling them in this fashion?
>
>Thanks
>Kirk