View Full Version : ABSVAL
01-01-1995, 02:00 AM
Currently I have an SQL statement that looks like this. SELECT * FROM FILENAME. I would like to return to my program the absolute value of a particular field, I do not wish to code every single field name (150+) if a use the ABSVAL buit-in function on only one field. How do I code the SQL statement? TIA
08-01-2000, 02:45 PM
Alan, I think you are saying that you want to be able to specify the "*" to grab all of the fields, but to also have one of the field values be the absolute value of it's value. Correct? If so, can't be done that I know of. You can get close though: <pre> Select f.*,absval(numfld) from file f </pre> Bill
08-01-2000, 04:00 PM
Bill, that's exactly what I was looking for. Thanks
Powered by vBulletin® Version 4.1.5 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.