Skip to Content (Press Enter)
UserImage.jpg
Leon Holmes
357Views
4Comments
Solved
OutSystems SQL Function Reference
Question
Traditional Web
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

0
0
31 Mar 2021
Copy Link
2018-10-29 08-31-03
João Marques
 
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

See solution in context
0
0
31 Mar 2021
Copy Link
2021-04-17 09-53-48
José Gonçalves

Hi Leon,

can you post the query here?

Thanks

0
0
31 Mar 2021
Copy Link
2018-10-29 08-31-03
João Marques
 
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

0
0
31 Mar 2021
Copy Link
UserImage.jpg
Leon Holmes

Thanks João.

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

Regards,

Leon

0
0
31 Mar 2021
Copy Link
2018-10-29 08-31-03
João Marques
 
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

0
0
31 Mar 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.