Skip to Content
0
Former Member
Jul 27, 2012 at 12:12 PM

Qualified table - delete Null

17 Views

Hi,

I have uploaded my qualified table, it had some NULL values and has got appended to my qualified table.

now my main table records have qualified table links with my No Qualifier populating as NULL.

ex.

ven1 city1 name1 companyCode1 CC1 desc1

compnay Code2 CC2 desc2

" " CC3 desc3

my third qualified link record is having " " in the NoQualifier(compnayCode) field,

I need to delete all the qualifed records with null values for my no qualifier OR

want to delete all the Qualified record tables.

pls let me know what is the best option and how it can be achieved

rgds,

ve