You have to use StdSQL92, i.e. % as wild char instead of *.
SELECT * FROM <TABLE> WHERE NAME LIKE '%saj%'
F.
> -----Original Message-----
> From: Sajeesh PJ [SMTP:[EMAIL PROTECTED]]
> 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?
>
> 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
