I need to know if this code will return a value back to me

DECLARE @TransNumber int
update control set @TransNumber=txnum=txnum+1
return @TransNumber

i call this from FoxPro with an sqlexec()
how do i get the value back from the server with the above statement.

TIA
SHAWN