If the field is a string field, should the syntax include an asterisk?

     select Table1 where Table1.Field1 like '15,10*';


On a related note, I found the inRange function in the Global class
useful to evaluate ranges in code - similar to what queries can do.

static void testInRange(Args _args)
{
    info(strfmt('%1',inRange('1..3',5)));
    info(strfmt('%1',inRange('1/1/06..1/31/06',today())));
}


Jim Chwaszczewski
[EMAIL PROTECTED]
----------
Message: 3        
   Date: Mon, 10 Apr 2006 09:33:04 +0530
   From: [EMAIL PROTECTED]
Subject: like - not working

Hi,

why the following qry is not working:

     select Table1 where Table1.Field1 like '15,10';


regs,
Hema. S
--------------------------------------------------------

The content of this E-mail and any attached files is confidential, and may be subject
to certain privilege.  This email is intended for the designated recipient(s) only. 
If you have received this E-mail in error, please immediately contact the sender.

Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties.
 


WIPFLI LLP
Business experts.  Right from the start.
--------------------------------------------------------





SPONSORED LINKS
Computer part Programming languages Microsoft axapta
Support exchange


YAHOO! GROUPS LINKS




Reply via email to