Error using TRIM on SQL SERVER

[michele-grifa]

Hi, i'm using the trim function in my project that retrieve some data from SQL Server.
In SQL Server 2017, the query works well, but on lower versions it gave me the error:

trim is not a recognized built-in function name sql server

I know that the trim function is not supported in SQL Server lower than 2017, but Exposed shouldn't adapt the query?
The odbc driver i'm using is:

com.microsoft.sqlserver:mssql-jdbc:7.4.1.jre8

[Tapac]

@HawkEye4 , sorry but it's not possible to track and support all dialect changes in all databases, but you always can make your own function like:

fun Column<String?>.trim2017() = function("LTRIM").function("RTRIM")

[michele-grifa]

@HawkEye4 , sorry but it's not possible to track and support all dialect changes in all databases, but you always can make your own function like:

fun Column<String?>.trim2017() = function("LTRIM").function("RTRIM")

Where should I place this function?

[michele-grifa]

Thanks, the code worked.