sel apstatus pon from master where apstatus = ' ' (a blank space between the quotes) or where appstatus is null
Depends on what your null setting is at the moment to know whether that first row is a space or is empty Is that what you wanted? Karen -----Original Message----- From: Steve Breen <[email protected]> To: rbase-l <[email protected]> Sent: Fri, Apr 22, 2016 6:36 pm Subject: [RBASE-L] - finding 2 bad data items in a colum in a table All What the best way to the two top items in the tally list from an R prompt R>tally apstatus from master apstatus Number of Occurrences ------------------------ --------------------- 2 /a 1 IP 39195 PPC 106479 RFA 61 n/a 63227 R> Used the following for the 2nd item R>sel apstatus pon from master where apstatus contains '/a' apstatus pon -------- ------------ /a B1401650 R> We have no date range to work with here. Thanks Stephen Breen CDI Services, Inc. 3610 Deahl Court P.O. Box 3838 South Bend, IN 46628 Cell - 574-532-7445 Fax 574-532-7445 -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
