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