[Axapta-Knowledge-Village] query range - like

2005-01-11 Thread anton_tjiptadi
I want to create query range with like and or criteria, something like this : (SQL Statement) select accountnum, voucher, * from ledgerjournaltrans where voucher like '%CPP%' or voucher like '%RV%' My statement rises an error if I wrote it like this one in X++ : sCrit = strFmt('((Voucher

Re: [Axapta-Knowledge-Village] query range - like

2005-01-11 Thread Lalith Jayantha
Hi anton Create a string type Extenderd data type and asign the string value to Extenderd data type ex: if Extenderd data type is "Likestring" assign the string value Likestring = '%RV%' select accountnum, voucher, * from ledgerjournaltrans where voucher like Likestring ; Lalith

RE: [Axapta-Knowledge-Village] query range - like

2005-01-11 Thread Steve Wright
S From: anton_tjiptadi [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 January 2005 12:32 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] query range - like I want to create query range with "like" and "or" criteria", something like thi