I Have done  my problem using your's solution,  thanks for your help.

Regards
dadan


-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] Behalf Of Thomas Jensen
Sent: Wednesday, June 08, 2005 7:39 PM
To: [email protected]
Subject: SV: [development-axapta] Substring in query


Try

while select  MyLedgerJournalTrans
          where MyLedgerJournalTrans.Txt like '123*'


Regards
Thomas

-----Oprindelig meddelelse-----
Fra: [email protected]
[mailto:[EMAIL PROTECTED] P� vegne af dadan_kasep_2
Sendt: 8. juni 2005 06:50
Til: [email protected]
Emne: [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











  _____ 

Yahoo! Groups Links


*      To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<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

Reply via email to