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", some

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 an

[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('((Vouch