Pesquisar parte do nome no Jsp (Firebird)

<%@page contentType=“text/html”%>
<%@page pageEncoding=“UTF-8”%>

<%@
include file=“ServerConfiguration.jsp”
%>

<%@
page import=“org.firebirdsql.jdbc.,org.firebirdsql.logging.Logger,java.sql.”
%>

<%

Class.forName(“org.firebirdsql.jdbc.FBDriver”);

Connection aConnection = DriverManager.getConnection(DatabaseAddr,UserName, Password);

Statement stmt = aConnection.createStatement();

String Sql=“Select * from clientes”;
ResultSet aQuery=stmt.executeQuery(Sql);

%>

<%–
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library… action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
–%>
<%–
<%@taglib uri=“http://java.sun.com/jsp/jstl/core” prefix=“c”%>
–%>

<h1>Selecionar por nome</h1>

<input type="text" name="vlr" value="" />

<%

while (aQuery.next())

{

%>

<%

}
%>

<%--
This example uses JSTL, uncomment the taglib directive above.
To test, display the page like this: index.jsp?sayHello=true&name=Murphy
--%>
<%--
<c:if test="${param.sayHello}">
    <!-- Let's welcome the user ${param.name} -->
    Hello ${param.name}!
</c:if>
--%>

</body>

Esta mostrando todos os registros, ok…mas gostaria de pesquisar parte do nome por exemplo como eu posso fazer isso??

Evandro