Math in a column

Can't I perform Math functions in deriving a column?
Check out the following SQL which DOES NOT work...
SELECT GEN.loan_num,
MKT.yield_prem,
MKT.yield_fee,
GEN.ysp_to_wire,
GEN.loan_amt,
(MKT.yield_fee =
(GEN.loan_amt *
(MKT.yield_prem/100)))
FROM DataTrac.dbo.GEN,
DataTrac.dbo.MKT
--WHERE GEN.loan_num = '2000013699'
WHERE GEN.file_id = MKT.file_id
AND NOT (MKT.yield_fee =
(GEN.loan_amt *
(MKT.yield_prem/100)))
Let me know.
Thanks.
wnfisbaCan you show DDL, sample data, desired results, and what "DOES NOT work"
means? Do you get an error message? If so, what is it?
Please read http://www.aspfaq.com/5006
"wnfisba" <wnfisba@.discussions.microsoft.com> wrote in message
news:486F6FD7-6217-41B3-B4E6-1DC92410B90D@.microsoft.com...
> Can't I perform Math functions in deriving a column?
> Check out the following SQL which DOES NOT work...
> SELECT GEN.loan_num,
> MKT.yield_prem,
> MKT.yield_fee,
> GEN.ysp_to_wire,
> GEN.loan_amt,
> (MKT.yield_fee =
> (GEN.loan_amt *
> (MKT.yield_prem/100)))
> FROM DataTrac.dbo.GEN,
> DataTrac.dbo.MKT
> --WHERE GEN.loan_num = '2000013699'
> WHERE GEN.file_id = MKT.file_id
> AND NOT (MKT.yield_fee =
> (GEN.loan_amt *
> (MKT.yield_prem/100)))
> Let me know.
> Thanks.
> wnfisba|||In the SELECT list, the last expression is a problem
SELECT ...,
(MKT.yield_fee =
(GEN.loan_amt *
(MKT.yield_prem/100)))
I don't know what you want this to be, but perhaps you are just
assigning the name yield_fee to the calculated amount? If so,
consider:
yield_fee =
(GEN.loan_amt *
(MKT.yield_prem/100)))
Roy
On Wed, 22 Feb 2006 13:37:30 -0800, "wnfisba"
<wnfisba@.discussions.microsoft.com> wrote:

>Can't I perform Math functions in deriving a column?
>Check out the following SQL which DOES NOT work...
>SELECT GEN.loan_num,
> MKT.yield_prem,
> MKT.yield_fee,
> GEN.ysp_to_wire,
> GEN.loan_amt,
> (MKT.yield_fee =
> (GEN.loan_amt *
> (MKT.yield_prem/100)))
>FROM DataTrac.dbo.GEN,
> DataTrac.dbo.MKT
>--WHERE GEN.loan_num = '2000013699'
>WHERE GEN.file_id = MKT.file_id
>AND NOT (MKT.yield_fee =
> (GEN.loan_amt *
> (MKT.yield_prem/100)))
>Let me know.
>Thanks.
>wnfisba