Skip to Content
0
Former Member
Mar 28, 2008 at 02:58 AM

Calculations in SQL

9 Views

I am trying to get a query to perform some math on some user fields so that this query could be made a formatted search for another user field ... all in the BOM.

DECLARE @X1 AS REAL

SET @X1 = $\[$3.U_PartLength\] * $\[$3.U_PartWidth\]

SELECT $\[$3.U_PartLength\], @X1

This code produces an error near "$3.U_PartLength"

The user fields are defined as "Units and Amounts" and "Quantity"

The reason I don't include the calculation in the SELECT statement is that this is the beginning of a complex series of calculations after which I will have to choose the lesser of two values.

Thank you,

Sal