Skip to Content
0
Former Member
Feb 16, 2009 at 04:31 AM

Queries Using 'Like'

12 Views

hi experts,

i having a problem to using ' like ' but no luck

SELECT T0.DocNum, T0.DocType, T0.DocDate, T0.CardCode, T0.CardName, T1.Dscription, T1.LineTotal FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocType='[%0]'AND

T0.DocDate>='[%1]' AND T0.DocDate <='[%2]' ORDER BY T0.DocDate ANDT0.CardCode like T%

I wanna show all the CardCode which is start by 'T'

How to do this?

Thanks.

Regards,

Danny.