SQL STATEMENT 1

[BRADENSTOKE]

How do I raise a number to a power in an SQL statement?
ie if DMN is a field with values of 1, 2 etc
I want to say FIELDNAME*(DMN-1^10) Frank.

 

[smin]

SELECT FieldName*POWER(DMN-1,10 )

 

[BRADENSTOKE]

Thanks Smin, I must be doing something wrong.
My statement is now (in part)
SELECT LPLI.LGTENR,TESTPR*POWER(LPLI.LGPDIM-1,10 ), etc
but I get the error "[IBM][Client Access Express ODBC Driver (32-Bit)[DB2/400 SQL]SQL0402 -- Use Not Valid"
Any Clues ?
As you can see from the error message, I am using AS400 Client Access.
Best regards. Frank.