I need help in identifying the missing numbers in a large query. The only problem is that some of the numbers may be alpha and numerical combined or not-they are mixed. Yet all the numbers are in the same column. The query looks like this SELECT MSPMP100.PRDNO,MSPMP100.CLASS,MSPMP100.DESCP FROM CARF1.MSPMP100 MSPMP100 Where MSPMP100.CLASS= ‘72′ MSPMP100.PRDNO is the field that would have the part numbers. and the DESCP is the one that would have the description (but there seems not to be any order to the way the description are entered) So I need to find the holes in the PRDNO and at the same time sort the entire list by the make and models of the DESCP....? Any input would be greatly appreciated
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!