I have a database with several fields... I only want certain fields to show in my results Some of the searched fields have the same value example: searched field is specific_p specific_p comment qty 68030 9845 0 68030 9844 100 68030 9843 12 68030rc50 9843 50 I want to show the 68030, but not the comment. I also don't want to show three seperate 68030s and pick one that is not 0 qty if there is one. Is there an MSSQL command to only get one of them? There may be other parts that are close too I want to search for %68030% to get all of them but show only one of them. I could probably write a filter, but WHY if it is built into SQL?
