>>Is there a way to execute a procedure from within a SQL select?
>>Such as this sample:
>>
>>

>>
>>select
>>name,
>>(exec dbo.GetAccountBalance customer.AccountNumber) as AccountBalance
>>From customer
>>
>>

>
> Mike why not,
>

>what_you_want = ...
>SQLEXEC(sqlHandler,[EXEC your_sp @first_param]= what_you_want,[sql_cursor])

>In your Stored Procedure
>

>SELECT name,....
>from...
>...

this is a SQL procedure not VFP