Jesper is correct.
You can use 'like' with wildcards ('*' for zero or more characters,
and '?' for a single character).
So in this case the criteria will be:
where ledgerTrans.Voucher like 'F111*'
Hope that helps
Andrew Jones
--- In [email protected], "Girish Bhatkal"
<[EMAIL PROTECTED]> wrote:
>
> If you write withing anything within ' ' then it will assume it to be an
> and you cannot get to choose wildcard entry. So you need to check
for the
> substring.
> If you are using the while select then with that statement you
cannot use
> to check substring. You could write a while statement and then
within that
> statement you can write a IF statement where you check for substring
> if(substr(LedgerTrans.Voucher,1,4) == 'F111')
>
> Good luck,
>
> Cheers,
> Girish
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: 14 March 2005 08:16
> To: [email protected]
> Subject: AW: [development-axapta] Select where with a filter
>
>
>
> Hi,
>
>
>
> You need to use * in Aaapra.
>
> If you are selecting with wildcards you need to use the keyword
"like" not
> "==".
>
>
>
> /Jesper
>
>
>
> Von: Padmaja Iyingar [mailto:[EMAIL PROTECTED]
> Gesendet: Montag, 14. M�rz 2005 05:06
> An: [email protected];
> [email protected]
> Betreff: [development-axapta] Select where with a filter
>
>
>
>
> Hi ,
>
> I am trying to select Sum of accounts's AmoustMST for that particular
> Voucher series.
>
>
> ///For example I want to sum up all accounts only for the voucher F111*.
>
> I can not do a substr in the select WHERE clause as its a database
field.
>
>
> 'select LedgerTrans where LedgerTrans.Accountnum >= 1000 &&
> LedgerTrans.AccountNUm <=2000 && LedgerTrans.TrandsDate= 1\1\2004 &&
> LedgerTrans.Voucher == 'F111%' is not working......
>
> I thought F111% is equal to F111*.
>
>
> How can I selectively select this one?.
>
> Can some one help please?
> Thanks,
> Padmaja Iyer.
>
> __________________________________________________
> 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]
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
>
> ADVERTISEMENT
>
>
<http://us.ard.yahoo.com/SIG=129cv5dhj/M=298184.6018725.7038619.3001176/D=gr
>
oups/S=1705006764:HM/EXP=1110873160/A=2593423/R=0/SIG=11el9gslf/*http:/www.n
> etflix.com/Default?mqso=60190075> click here
>
>
>
>
<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=
> :HM/A=2593423/rand=420965999>
>
>
>
> _____
>
> 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!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> Yahoo! Groups Links
| Yahoo! Groups Sponsor | |
|
|
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.
