Skip to Content
0
Jan 12, 2011 at 10:20 AM

help in a query

26 Views

Dear,

I have a query bellow. Please, could you help me with searching only comments starting with K10//? I have a list of all delivery lists created 11-01-11 bellow a query and I would like to choose only delivery lists starting with e.g K10.

SELECT T0.[DocNum], T0.[TaxDate], T0.[CardCode], T0.[CardName], T0.[Ref1], T0.[NumAtCard], T1.[SeriesName], T0.[TransId], T0.[Comments] FROM ODLN T0 INNER JOIN NNM1 T1 ON T0.Series = T1.Series WHERE T0.[TaxDate] =[%0] AND T1.[SeriesName] =[%1]

10/01/2011// Založeno na Zakázky odběratele 11100059.

K9//Kvelb/OV1-4/2011/doobjednávka// Založeno na Zakázky odběratele 11100058.

K9//OV1-9/2011/Libuu0161// Založeno na Zakázky odběratele 11100057.

K10//Založeno na Zakázky odběratele 11100060.

K10//Založeno na Zakázky odběratele 11100063.

K10//OHo-22/2011/Holeu0161ovice// Založeno na Zakázky odběratele 11100061.

K10//NOBVP110037// Založeno na Zakázky odběratele 11100044.

K10//OV-22/2011// Založeno na Zakázky odběratele 11100047.

K10//04552-1/ Založeno na Zakázky odběratele 11100050.

Thank you

jonmar7