Hi Mukesh,
Thank u.
regs,
Hema. S
hello world
<[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 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/
