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

<*> 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/
 



Reply via email to