>>I put a "wish" in the Wishlist to send SQL Select to a memory variable.
>>It would only work if your code returned one col. and one row;
>>else give an error.
>>I "believe" SQL Server lets you do this.
>
>Not really. SQL returns (at least to VFP) everything in a cursor. That cursor may only have one row and one field, but it's still a cursor, not a variable.
I was thinking of SET @var = SELECT oneField ...
within SQL Server. I haven't done SQL Server in a while, so I may have the syntax wrong.
- Andy Rice
San Diego, CA