General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Finding Last Dash Number
Environment versions
Network:
Windows 2000 Server
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only