Hi,
it is not possible to use such a query , which is similar to the "in" in
SQL. In SQL we can give "select Table1 where Table1.Field1 in
('10','15','23')" and this will return all the records with the value 10 or
15 or 23 in Table1.Field1 .
Reason: Not supported.
As you have rightly mentioned, you will have to queryrange.
but if you still insist on using a sql statement, well, u can give something
like " select Table1 where Table1.Field1=='10' || Table1.Field1=='15' ||
Table1.Field1== '23' " .
Happy querying!!! :-)
Regards.
On 4/11/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
> i want to fetch records from Table1 for values '10','15','23','36' of
> Field1. i can get the result for this query using queryrange. but i want
> to
> know why i am not getting thro' the following like statement.
>
> select Table1 where Table1.Field1 like '10,15,23,36';
>
> provide the solution. Thank u.
>
> regs,
> Hema. S
>
>
>
>
> "Raj Kumar"
> <[EMAIL PROTECTED]> To:
> Axapta-Knowledge-Village@yahoogroups.com
> Sent by: cc:
> [EMAIL PROTECTED] Subject: Re:
> [Axapta-Knowledge-Village] like - not working
> groups.com
>
>
> 04/11/2006 12:03 PM
> Please respond to
> Axapta-Knowledge-Village
>
>
>
>
>
>
> Hi Hema,
> what is that you are trying to achive?
> are you trying to get
>
>
> On 4/11/06, mohit rajvanshy <[EMAIL PROTECTED]> wrote:
> >
> > Hi Hema,
> >
> > Try this
> > Select table1 where table1.field1 like '1*';
> >
> > it will fetch all the records where the field1 value
> > is starting from 1.
> >
> > If you want only two letters then you can use '1?'
> > instead of '1*'
> >
> > It is like wild charcaters.
> >
> >
> >
> > --- [EMAIL PROTECTED] wrote:
> >
> > > Hi,
> > >
> > > why the following qry is not working:
> > >
> > > select Table1 where Table1.Field1 like '15,10';
> > >
> > >
> > > regs,
> > > Hema. S
> > >
> > >
> > >
> >
> >
> > Regards
> > Mohit Rajvanshy
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> >
> >
> > Sharing the knowledge on Axapta.
> > Visit www.frappr.com/axapta for axapta friends.
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
>
>
>
> SPONSORED LINKS
>
> Business finance Business to Small business
> course business finance finance
>
> Business finance Business finance Business finance
> consultant magazine schools
>
>
>
> YAHOO! GROUPS LINKS
>
> Visit your group "Axapta-Knowledge-Village" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
