How to delete rows based upon a condition
I have a joined data table and i would like to select & delete rows if two condition are both simultaneously met.Character Condition1= Missing a name in column ("NAME")Character Condition2= Character value in column ("NO") is L9% & exists where there are various character values in the table (ie. L921000, L939456, L999999, etc.)Is there a way to do this since i don't think i can use an sql wildcar...