ABSVAL

[Guest.Visitor]

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

[Guest.Visitor]

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

[Guest.Visitor]

Bill, that's exactly what I was looking for. Thanks