Hi,
Try to use '%' instead of '*'.
Select <column(s)> from <table(s)> where SearchColumn like '%ba%';
.Cezar.
On Wed, 23 Jun 1999, Ugur Serkan Taskin wrote:
> Hello All,
> this may be a little bit off-topic... but I need your help.. The problem
> seems very simple but I couldnt manage to work it out.
>
> I have a very simple query :
>
> SELECT FirmInfo.FirmTitle, FirmInfo.GOTel1, FirmInfo.GOFax From FirmInfo
> WHERE FirmInfo.FirmTitle LIKE '*ba*';
>
> This works fine in MS Access 7.0.
>
> Here I want to find FirmTitles including the character sequence "ba". If I
> omit the * character in the LIKE '*ba*' statement it works from the Java
> Servlet for an exact match. But if I add the * character, I get nothing for
> the result set.
>
> Is there anybody who can advice me a way to cope with that problem. Or any
> other technique?
>
> Thanks a lot.
>
> ugur serkan
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
