Really have problem to construct SQL to compare things where not
equal to. I have things like using addrange.value(Strfmt
(_expression_)), but the result is just undesire.
Can anyone tell me how to construct sql queries like (Example) using
Axapta?
1. Select * from CustTable where name not like '*a*'
2. Select * from CustTable having name in ['Stephen', 'David']
3. Select * from CustTable where substr(name, 1,2) = 'c';
thks in advance.
| Yahoo! Groups Sponsor |
| Get unlimited calls to U.S./Canada |
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.
