You didn't explain what you want to do. Anyway, see corrections in the code below that will allow to run that select.

>OK, here is the code that is just making my head hurt today:
>

>DECLARE @LoanAmount money
>DECLARE @LoanID Int
>SET @LoanId=267
>--LOAN
select @LoanAmount=((loanamount+loanfee)-amtdiscount) from tblloans where id=@LoanID
>

>
>It keeps giving me the "A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations." error . . . Any alternative way to do this?
>