I have to figure out the items that Legal Name implies individual but Legal Entity Structure indicates a incorporation type. In this sample, you can see Alexander, Justin N. is my target. But my problem is how should I use a query to figure out which one is a individual's name? and any one can provide me the script with this question? Thank you very much!
Legal Name ///////////////////////////////////////////// Legal_Entity_Struct
S & H Farm Supply, Ltd./////////////////////////// Company
F.M.Abbott Power Equipment,Co.////////////// Company
Ray's Dixie Chopper, Inc.////////////////////////// Company
Alexander, Justin N. ///////////////////////////////// Company
Alameda Power Equipment, Inc.//////////////// Company
Dun-Rite Appliance Co. Inc./////////////////////// Company
Edwards Furn. Of Crystal //////////////////////// Company
Baker's, Company ///////////////////////////////////// Company
Tennies Hardware, Inc.////////////////////////////// Company
Heinold and Feller Tire Co., Inc.////////////////// Company
Milton Village Hardware, Inc. ////////////////////// Company
Crane & Son, Inc./////////////////////////////////////// Company
Triple D Equipment, Inc///////////////////////////// Company
Merritt, Stephen C. //////////////////////////////////////Sole Propriertorship
Cane Equipment Cooperative, Inc. //////////////Company