Hi!
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
> Sajeesh PJ
> Sent: Friday, January 14, 2000 2:10 AM
> To: [EMAIL PROTECTED]
> Subject: LIKE Query
>
>
> Hai,
> I have a problem with Access when used with jdbc:odbc bridge.When I
> execute the querry "SELECT * FROM <TABLE> WHERE NAME LIKE '*saj*' in the
> console of MS ACCESS I get some rows which satisfy the condition.But when I
> execute the same querry using JDBC I get 0 Rows. It seems that LIKE is not
> supported by ODBC. I had similar excerience when I tried to execute the
> LIKE querry using CRecordset as well. Do u have any solutions?
>
Try ... like '%saj%' ... The wildcard operator in SQL is mostly the '%'
character ....
Hope it helps -
kind regardsm
Simon
> Thanks & Regards
> sajeesh
>
> _________________________________________________
>
> Get Your Free Email At, http://www.rediffmail.com
>
> ___________________________________________________________________________
> 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
