public static String composeWhereForNum(String sql, String fieldName,
			String fieldValue, int action) {
		// String sTmp = String.valueOf(fieldValue);
		if (fieldValue == null || fieldValue.trim().compareTo("") == 0)
			return sql;
		String sTmp = fieldName + " = " + fieldValue;
		switch (action) {
		case EQUAL:
			break;
		case LIKE:
			break;
		case GE:
			sTmp = fieldName + " >= " + fieldValue;
			break;
		case LE:
			sTmp = fieldName + " <= " + fieldValue;
			break;
		case IN:
			sTmp = fieldName + " in (" + fieldValue + ")";
			break;
		}
		if (sql == null || sql.trim().compareTo("") == 0)
			return " WHERE " + sTmp;
		else
			return sql + " AND " + sTmp;
	}