String aQuery = "select s from Stateabbv s where upper(trim(s.name)) = '" + pStateName.toUpperCase() + "' " ;
Query aQueryObject = manager.createQuery(aQuery);
entity = (Stateabbv)aQueryObject.getSingleResult();
}
catch(Exception pException) {
throw new PersistenceException("State does not exist");
}
return entity.getAbbv();
}