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 wildcard% or do i need to change this column to a number (by removing the L & changing it from character to numeric) and then i can chose values >899,999.
The error is in the 2nd part of my select where statement dealing with condition 2 (L9 character values)
DATA3=Data Table( "DATA1" ) << Join( With( Data Table( "DATA2" ) ), Merge Same Name Columns, By Matching Columns( :NO = :NO ), Drop multiples( 1, 1 ), Include Nonmatches( 1, 1 ), Preserve main table order( 1 ), Output Table( "MERGE3" ) );