>I need a Select statement to find the last dash number in a series of partnumbers. Each record in my table has a unique sequence number. The table contains all partnumbers. The greatest sequence number represents the last partnumber that was entered and thus will be the last or greatest dash number for that series. So I need to isolate a series of partnumbers, records where the first six numbers are the same, then figure out from the dash suffixs(-401, -403, -405) which is the greatest.
>
>The table is accessed remotely by SPT.
>
>This is needed to control what the next dash number the user can create is.
select Left(PartNum,6) as Series, max(substr(PartNum,8)) as DashNumber from myTable group by 1
? Assuming that dash always starts from the 7th position.
If it's not broken, fix it until it is.
My Blog