Re: Question
Posted in 1995
Champakavalli Madineni (madineni@usceast.cs.scarolina.edu) wrote: : I want to know if there is a function in informix to convert negative : numbers to positive numbers. Eg. -5 as 5. Please let me know. An absolute value function doesn't exist, but you can easily create your own: FUNCTION abs(value) DEFINE value int IF value < 0 THEN LET value = value * -1 END IF RETURN value END FUNCTION -- ____ ___ ________ ________ /_ _] /_ ]/ ______)/ ______) _/| Steve Morrow, Sr. Programmer/Analyst / _/ / / / (____ / /___ _/ | University of South Florida / _/ / / \\____ ) / _____) _/ | Internet: smorrow@dotrisc.cfr.usf.edu / _/___/ / ______/ / / / _/ | Voice : (813) 974-6889 (_________)(________)(___)______/ |______________________________________