How to search record on (firstname+lastname) or (lastname+firstname)? please help me

Hi
I need your help to resolve the following issue.please, help me.
I need to search employee on (firstname+lastname) or (lastname+firstname). SQL-2000 is DB.
the piece of code is as follows

public List getEmployeeSearchDetails(Integer teamId, String empname)
	throws DataAccessException, ServiceException {
                   Connection con = null;
 	   CallableStatement cstmt = null;
	    ResultSet rs = null;
	    java.util.ArrayList employeesearchDetailsList = null;
                 
                      try {
	           con = super.getReadOnlyConnection();
                          String str[]= empname.trim().split("\\s");			 	 
 	           cstmt = con.prepareCall(qryforEmployeeSearch_fullname);			 	 
	           DBHelper.bindString(cstmt, 1,str[0]+ "%");
	           DBHelper.bindString(cstmt, 2,str[1]+ "%");
                          }
                      rs = cstmt.executeQuery();
                 catch()
                {}
              }[/color][/b] 
         DBHelper class is as 
           
           [b][color=blue] public final class DBHelper
                     {
                        public static void bindString(PreparedStatement stmt, int idx, String data)
	          throws SQLException {
	         if (StringUtil.isEmpty(data)) {
		stmt.setNull(idx, Types.VARCHAR);
		return;
		}		
		stmt.setString(idx, data);		
	}
                     }

On execution, I am getting "nested exception is: java.sql.SQLException: [IBM][SQLServer JDBC Driver]Invalid parameter binding(s). "

How to resolve? please, help me.

regards
Gautam

What is the SQL behind qryforEmployeeSearch_fullname ?

it is as below

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 ";

regards
Gautam

So you have four bind parameters declared but you only bind two. You'll need to bind all of these.

many many thanks to you. it's working as i changed
regards
gautam