MarkMpn / Sql4Cds

SQL 4 CDS core engine and XrmToolbox tool
MIT License
74 stars 22 forks source link

[Feature Request] STRING_SPLIT support #412

Closed sybaris closed 2 months ago

sybaris commented 9 months ago

Hi,

Using SSMS, this query runs :

SELECT value AS sous_chaine
FROM msdyn_ciprovider
CROSS APPLY STRING_SPLIT(msdyn_appselector, ';');

On Sql4Cds, I have the following error : Unhandled table reference: STRING_SPLIT(msdyn_appselector, ';')

It should be great to have this feature too on Sql4Cds...

Regards Sybaris