-- Notes, Invisible - List.sql
/* 2014-08-23 Tom Holden ve3meo
GEDCOMs imported from TMG and other programs may have 
notes imported to the RootsMagic primary Name that become 
invisible to the RM 6.3.1.4 user interface. This query
lists them. A sister query converts them to general notes.
*/

SELECT NameID, Surname, Given, OwnerID AS RIN, Note 
FROM NameTable 
WHERE Note NOT LIKE '' AND IsPrimary