I normally just append the %'s to the variable. e.g.
sFirstName = '%' + sFirstName + '%'; SimpleQuery q = new SimpleQuery(typeof(nCustomer), "from nCustomer c where c.FirstNames like ? order by c.Surname", sFirstName); ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ CastleProject-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/castleproject-users
