On Tue, 25 Mar 2008 12:43:08 GMT, "acraft" <u42371@uwe> wrote:

You need to put that T-SQL code in a stored procedure, and return the
string via an OUTPUT parameter.

-Tom.


>How do you capture this variable from SQL Server?
>Example of T-SQL code:
>
>declare @strVariable varchar(20)
>set @strVariable = 'This was a success...'
>select @strVariable as NEW_FIELD
>
>How do I capture the returned value "This was a success..." without creating
>a temporary table on the SQL Server? I am using MS Access and trying to use
>the ADO.Recordset.
>
>
>Should I use a different method? Any suggestions or sample code?

On Tue, 25 Mar 2008 07:13:04 -0700, Tom van Stiphout
<(E-Mail Removed)> wrote:

Oops, Brendan is right. You can return it from a Select statement as
well.
-Tom.


>On Tue, 25 Mar 2008 12:43:08 GMT, "acraft" <u42371@uwe> wrote:
>
>You need to put that T-SQL code in a stored procedure, and return the
>string via an OUTPUT parameter.
>
>-Tom.
>
>
>>How do you capture this variable from SQL Server?
>>Example of T-SQL code:
>>
>>declare @strVariable varchar(20)
>>set @strVariable = 'This was a success...'
>>select @strVariable as NEW_FIELD
>>
>>How do I capture the returned value "This was a success..." without creating
>>a temporary table on the SQL Server? I am using MS Access and trying to use
>>the ADO.Recordset.
>>
>>
>>Should I use a different method? Any suggestions or sample code?