Recent content by Jasper321

  1. J

    Using LEFT and UCASE Together with GROUP BY?

    Here is the ODBC SQL that doesn't work: SELECT AL1.cono, {fn UCASE( {fn LEFT( AL1.whse, 1)} ) } AS WhseLoc, Count (AL1.orderno) FROM PUB.oeeh AL1 WHERE (AL1.cono=1 AND AL1.enterdt >= { fn CURDATE()} -1 AND AL1.stagecd BETWEEN 1 AND 5 AND AL1.ordersuf=0 AND (NOT AL1.custpo LIKE '%@t%') AND...
  2. J

    Using LEFT and UCASE Together with GROUP BY?

    I am going against a V9 Progress DB using ODBC on Windows with Brio. I have available the functions 'LEFT' and 'UCASE' which I need to use. I can use either one with success but if I try to nest these I get a GROUP BY error or syntax error. I have tried many ways with no success. Is there a...
See more
Back
Top