@Entity
@Table(name = "ADDRESS")
**// may be @Table("select * from ADDRESS where not (ADDRESS like '*PO Box')")**
public class Address
{
 @Id @GeneratedValue(strategy = GenerationType.IDENTITY)
 public Long id;


@Column(name = "ADDRESSOFPERSON")
private String address;

@ManyToOne
@JoinColumn(name = "PERSONNAME")
private Person person;
...
}

@Entity<br>
@Table(name = "PERSON")
public class Person
{
@Id
@Column(name = "NAME")
private String name;

@OneToMany(targetEntity=Address.class,mappedBy="person")
private List<Address> addresses;

    public List<Address> getAddresses() {
    EntityManager em ; // get EntityManager some how
    Query q = em.createQuery("SELECT o FROM Person o WHERE (o.address like '%PO Box%') ");
    **// THIS IS WHAT I DONT WANT TO DO**
    return (List<Address>) q.getResultList();
}
...

}

**Usage**
public class Bean
{
 @PersistenceContext
 private EntityManager em;
   public List<Person> allPersons(String studentId)
   {
        String sql ="SELECT o FROM Person o";
        Query query = em.createNamedQuery(sql);

        return (List<Person>) query.getResultList();
    }
}