[development-axapta] Having / like relational operators

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 c

[development-axapta] 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 no