OutSystems SQL Function Reference
Application Type
Traditional Web
Service Studio Version
11.10.15 (Build 40206)

I have not bee successful in obtaining a SQL Function reference in the documentation.  Can someone assist?

I have used "Max" and that works fine.  I have tried "Trim" and I get an error that it is not a recognized built-in function.  I know the OutSystems built-in functions but not the SQL functions.

Thanks

Leon

mvp_badge
MVP
Solution

Hi Leon,


In SQL Server the built-in functions are LTRIM() and RTRIM() for left trim and right trim, respectively.


For example:


SELECT LTRIM(RTRIM({Client}.[Name])) FROM {Client}


Kind Regards,
João

Hi Leon,

can you post the query here?

Thanks

mvp_badge
MVP
Solution

Hi Leon,


In SQL Server the built-in functions are LTRIM() and RTRIM() for left trim and right trim, respectively.


For example:


SELECT LTRIM(RTRIM({Client}.[Name])) FROM {Client}


Kind Regards,
João

Thanks João.

That solves my problem, but I would like to have a full reference of SQL functions for future use.

Regards,

Leon

mvp_badge
MVP

Hi Leon,


I'm glad I could help.


If you need more information from SQL Server functions, you can check Microsoft documentation here.
You will find the LTRIM, RTRIM and others under the subsection STRING.


Kind Regards,
João

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.