Hi Pepe,
For example:
ResultSet res = stmt.executeQuery('SELECT NAME FROM CUSTTABLE
WHERE (NAME LIKE \'Name_%\')');
If you have more then one like then or them together.
Alternatively you can use a query and add whatever ranges you need to it.
Regards,
--
Luis Mour�o
[EMAIL PROTECTED]
--- In [EMAIL PROTECTED], "pepejeans2k"
<[EMAIL PROTECTED]> wrote:
>
>
> 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 | |
|
|
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.
