I would like to convert the following SQL to X++
case when CHARINDEX('-',REVERSE(NAME)) > 0 then right(NAME,CHARINDEX('-',REVERSE(NAME))-1) else Name end as Name
*This post is locked for comments
Hi Jezem,
I think you can use While select.
https://docs.microsoft.com/en-us/dynamicsax-2012/developer/while-select-statements
CharIndex change to use strScan.
https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/dev-ref/xpp-string-run-time-functions#strscan
You can either implement it in the application layer (as suggested by Blue Wang), or you can use your SQL code in a computed column in a view (which would allow you to filter and sort by this column).
= strDel(name, 1, strScan(name, '-', strLen(name), -strLen(name)));
Did you have problems using it? Or has it been solved?
Please describe the problem.
Thank you.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 4
Martin Tocauer 4
Nayyar Siddiqi 2
