Hi,
Maybe you can use this.
select Table1
where Table1.Field1 = '10'
or Table1.Field1 = '15'
or Table1.Field1 = '23'
or Table1.Field1 = '36';
I hope this will help you.
--- In Axapta-Knowledge-Village@yahoogroups.com, [EMAIL PROTECTED]
wrote:
>
>
> Hi Mukesh,
>
> Thank u.
>
> regs,
> Hema. S
>
>
>
>
> hello
world
> <[EMAIL PROTECTED]> To: Axapta-
[EMAIL PROTECTED]
> Sent by:
cc:
> [EMAIL PROTECTED]
Subject: Re: [Axapta-Knowledge-Village] like - not
working
>
groups.com
>
>
> 04/11/2006 04:23
PM
> Please respond
to
> Axapta-Knowledge-
Village
>
>
>
>
>
>
> Hi Hema,
>
> you want to select multiple records but this select
statement
> first selects the record for value 10, as soon it gets 10 it stops
and
> return only one record. if you want to select records with only
two digits
> in a particular field then you can use while statement as..
>
> while select Table1 where Table1.Field2 like "??"
>
> hope that it will help you,
>
> Regards,
> Mukesh
>
> [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
>
>
> 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.
>
>
> ---------------------------------
>
>
>
>
>
> ---------------------------------
> Jiyo cricket on Yahoo! India cricket
> Yahoo! Messenger Mobile Stay in touch with your buddies all the
time.
>
> [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
<*> 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/
