I have faced this problem in ADO. Possibly try using % instead of *. It
might work.

Dev
----- Original Message -----
From: Rowena Perks <Rowenap@w...>
To: sql language <sql_language@p...>
Sent: Wednesday, November 15, 2000 4:01 PM
Subject: [sql_language] need help w/sql statement


> -----Original Message-----
> From: Dave Widly [mailto:dlwidly@p...]
> Sent: 14 November 2000 17:15
> To: support@w...
> Subject: need help w/sql statement
>
>
> I have been trying to run this query but get back no records.  Does sql
> support the like statement, I tested this in access linked to the same sql
> table and it works great but from asp no worky.  Here is my statement and
> connections called in my asp.  I don't know if your support covers
> questions
> like this, your asp books have been great I guess its time to buy an sql
> one.
>
> SELECT FGTId, SGTId FROM TermGroups WHERE GTType=1 And CliId='EWW' And
> FGTId
> Like 'EMW-EAR-EA1*' ORDER BY SGTId;
>
> Set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open "DSN=TSWO; UID=sa; PWD="
> SET RS = Conn.Execute(sql)
>
> Note sql=above sql statement
>
> Thank You,
>