towt@infonode.ingr.com (Tim Tow) (02/03/91)
Is it possible to break on a substring of a break column defined in the Ingres ReportWriter? For example.. a field contains the following data: 33045590 33045592 33045595 33902178 33902199 The field is contained in the table called by the .query statement. What I want to to is to subtotal (break) after the "3304" series and after the "3390" series but I want to avoid putting another field into the data table ( I realize I could use the left() function in SQL to split out the 4 left digits into a discrete field). I also can't use the left() function to get this data separately in the .query statement because the select statement is in this form: select * from $TABLENAME This didn't seem to work very good either: .break left("fieldname") or this: .break "fieldname" .footer left("fieldname") Any ideas?? ------------------------------------------------------------------------------ | Tim Tow | | | Intergraph Corporation | "Injustice anywhere is a | | International Finance-Huntsville, AL | threat to justice everywhere" | | Mailpath: ..!ingr!b10!fin2!timtow | | | Voice: 205-730-2117 | - Dr Martin Luther King, Jr | | | | "Opinions expressed here are usually mine or like mine.. not my employers" | ------------------------------------------------------------------------------