The AS 400 Has lots of Scalar functions. Here are the catagories that I have documented.
Numeric AS400 Scalar Functions String AS400 Scalar Functions Date/Time AS400 Scalar Functions Misc AS400 Scalar Functions