Forgive the commented out lines. I'm still tweaking it. Query where the Cast under Group By doesn't work followed by the one that does work.

SELECT

SOIL.COMPANY_CODE

, SOIL.ORDER_NUMBER

, SOIL.ORDER_LINE_NUMBER

, SOIL.ORDER_SEQUENCE...

I tried that with this command and receive a "Invalid length parameter passed to the SUBSTRING function."

SELECT

REVERSE(LEFT(REVERSE(PART_CODE), CHARINDEX(':', REVERSE(PART_CODE))-1))

FROM...

Hi, I've looked at the sql tools setup log and couldn't find an error that looked right. The file is about 22 MB so I could've overlooked something. ...