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

Reply via email to