If you are using straight SQL, just build the statement as you've
specified.
If you are using Axapta's embedded SQL, try using the MATCH function in
your where clause.
If you are using a query, the query range value can use wildcards,
ranges, etc.
Both the Match function and query values can use Axapta's version of
regular expressions.
Jim Chwaszczewski
Wipfli, LLP
Date: Thu, 28 Oct 2004 09:07:46 -0000
From: "pepejeans2k" <[EMAIL PROTECTED]>
Subject: Having / like relational operators
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.
--------------------------------------------------------
The content of this E-mail and any attached files is confidential, and may be subject
to certain privilege. This email is intended for the designated recipient(s) only.
If you have received this E-mail in error, please immediately contact the sender.
WIPFLI LLP
Business experts. Right from the start.
[Non-text portions of this message have been removed]
| 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.
