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

  I think sCrit should be a comma separated list "*CPP*,*RV*"  as this is standard Axapta syntax when entering filters, eg in the Ledger Transactions Inquiry form. You should not need to know ANY SQL to do an Axapta query - tableid and fieldid/values should be enough.     S   From:

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

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