Announcements
No record found.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
