try this
while select MyLedgerJournalTrans
where MyLedgerJournalTrans.Txt like '123*'
You can use a pseudoSQL sintax for operator like in axapta, with the following wildcards: ? = single char replacement, * = whole string replacement.
Hope this helps.
Regards
Alex
________________________________
Da: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Per conto di dadan_kasep_2
Inviato: mercoledì 8 giugno 2005 6.50
A: development-axapta@yahoogroups.com
Oggetto: [development-axapta] Substring in query
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] <mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
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.