Fortunately, someone posted a right answer before.
--- andreas_paulsson_cimkey_se
<[EMAIL PROTECTED]> escribi�:
> No, I am afraid that this won't work either as it
> will find records
> where MyLedgerJournalTrans is 1233453453, 012335345,
> 87777123 etc.
>
> I think it should be
>
> while select * from MyLedgerJournalTrans where
> MyLedgerJournalTrans like '123*'
> {
> }
>
> Note that of You wanted
> substr(MyLedgerJournalTrans.Txt,3,3), it would
> look like
>
> while select * from MyLedgerJournalTrans where
> MyLedgerJournalTrans like '??123*'
> {
> }
>
> ? stands for a single character
> * stands for zero or more characters.
>
> /Andreas
>
> --- In [email protected], Roberto
> Pineda
> <[EMAIL PROTECTED]> wrote:
> > Try this:
> >
> > while select * from MyLedgerJournalTrans where
> > MyLedgerJournalTrans like '*123*' {
> > }
> >
> > it should works.
> >
> > Roberto
> >
> >
> > --- axapta developer <[EMAIL PROTECTED]> escribi�:
> >
> > > hi Dadan,
> > >
> > > Perhaps you could try working around it:
> > >
> > > while select * from MyLedgerJournalTrans
> > > {
> > > if(substr(MyLedgerJournalTrans.Txt,1,3) ==
> > > '123')
> > > do something;
> > >
> > > }
> > >
> > >
> > > dadan_kasep_2 <[EMAIL PROTECTED]> wrote:
> > > I have problem with substring in query like :
> > >
> > > while select MyLedgerJournalTrans
> > > where
> substr(MyLedgerJournalTrans.Txt,1,3)
> > > == '123'
> > >
> > > Does anyone have any suggestions to solve this?
> > >
> > > thank's
> > > Regards
> > >
> > > Dadan s
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Yahoo! Groups Links
> > >
> > > To visit your group on the web, go to:
> > >
> http://groups.yahoo.com/group/development-axapta/
> > >
> > > To unsubscribe from this group, send an email
> to:
> > > [EMAIL PROTECTED]
> > >
> > > Your use of Yahoo! Groups is subject to the
> > > Yahoo! Terms of Service.
> > >
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam? Yahoo! Mail has the best spam
> > > protection around
> > > http://mail.yahoo.com
> > >
> > > [Non-text portions of this message have been
> > > removed]
> > >
> > >
> > >
> > >
> >
> >
> > Roberto Pineda
> >
> > __________________________________________________
> > Correo Yahoo!
> > Espacio para todos tus mensajes, antivirus y
> antispam �gratis!
> > Reg�strate ya - http://correo.espanol.yahoo.com/
>
>
>
>
>
Roberto Pineda
__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam �gratis!
Reg�strate ya - http://correo.espanol.yahoo.com/
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
