Share
ReportI need string functions which can used in X++. Specially I need sub string function, how we can get sub string using SQL query.
*This post is locked for comments
You’re offline. This is a read only version of the page.
2,055
I need string functions which can used in X++. Specially I need sub string function, how we can get sub string using SQL query.
*This post is locked for comments
X++ queries don't support such a kind of things. Consult the documentation (Select Statement Syntax [AX 2012]) if you don't know what's supported.
To achieve what you need, create a view with a computed column, handle the logic in the application layer or, as the last resort, run a direct SQL query.
Sorry actually I need sql sub string function to use in X++. I have try the following code but its not working.
select subStr(ChequeNum,1,3) from bankChequeTable
group by bankChequeTable.ChequeNum;
info(bankChequeTable.ChequeNum);
X++ function for substrings is called simply subStr().
Nevertheless database servers don't understand X++, so you can't use X++ function in SQL commands.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (