Urgently need help with this sql problem

Alexander, Justin N. also having Legal Entity Struct as company. But how to identify the value is company name or individual name?

If you are searching for Alexander just using like 'Alexander%' will give you the required result. Kindly elaborate the result which is required