how to read returned values from sql function
<blockquote>
  <p><strong>Possible Duplicate:</strong><br>
  <a href="http://stackoverflow.com/questions/706361/getting-return-value-from-stored-procedure-in-c-sharp">Getting return value from stored procedure in C#</a>  </p>
</blockquote>



<p>im using the following sql function in a c# winform application</p>

<pre><code>create function dbo.GetLookupValue(@value INT)
returns varchar(100)
as begin
  declare @result varchar(100)

  select
    @result = somefield
  from 
    yourtable
  where 
    ID = @value;

  return @result
end
</code></pre>

<p>my question is: how can i read the returned @result in c#? </p>
