SELECT @Loc_Price = Bill_Master.Amt, @tds = Bill_Master.Amt + 1
FROM Bill_Master
...
>Hi All:
>How can I save the value of a field in a variable in my select
>statement.
>
>For example:
> SELECT Bill_Master.Amt as Loc_Price,
> Loc_Price + 1 as As tds
>
>I want to save the value of amt in a variable call Loc_Price and select
>Loc_Price + 1 as tds
>
>Thanks
--sb--