ayha1999
asked on
SQL max command
I have the follwoing data in the table.
wID
WS-1000
IS-1001
MS-10001
Two letters, a hyphen then number 4 to 5 digits. How can I select the maximum number from the digit part?
thanks
ayha
wID
WS-1000
IS-1001
MS-10001
Two letters, a hyphen then number 4 to 5 digits. How can I select the maximum number from the digit part?
thanks
ayha
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER