This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
private static final String qryforEmployeeSearch_fullname ="select e.emp_eid, rtrim(ltrim(e.emp_firstname)) +' '+rtrim(ltrim(emp_lastname))+' ['+e.emp_eid+']' as emp_name," +
" e.emp_tm_tid as teamname from tblEmployee e where " +
"(e.emp_lastname like ? and e.emp_firstname like ?)or (e.emp_firstname like ? and e.emp_lastname like ?) order by e.emp_firstname ";