KG360 Posted September 26, 2022 Report Share Posted September 26, 2022 Hi, What would be the appropriate syntax to insert line breaks when extracting texts through SELECT statements, such as the one below: (SELECT Definition FROM _v_vw_360OrgTypes WHERE OrganizationTypeID=target.[@field:Organization_type]) +'. '+(SELECT Description FROM _v_vw_360OrgTypes WHERE OrganizationTypeID=target.[@field:Organization_type]) Are there other expressions to modify the texts? Anywhere I can find examples? Appreciate any input! /Gunnar Quote Link to comment Share on other sites More sharing options...
0 GoodBoy Posted September 26, 2022 Report Share Posted September 26, 2022 Hello! You can use CHAR(10) or CHAR(13) syntax. Just put it where you want to start a new line. For example. 'Hi' + CHAR(10) + 'Hello' KG360 1 Quote Link to comment Share on other sites More sharing options...
0 KG360 Posted September 26, 2022 Author Report Share Posted September 26, 2022 1 hour ago, GoodBoy said: Hello! You can use CHAR(10) or CHAR(13) syntax. Just put it where you want to start a new line. For example. 'Hi' + CHAR(10) + 'Hello' Perfect - many thanks @GoodBoy, it works fine!!! GoodBoy 1 Quote Link to comment Share on other sites More sharing options...
Question
KG360
Hi,
What would be the appropriate syntax to insert line breaks when extracting texts through SELECT statements, such as the one below:
(SELECT Definition FROM _v_vw_360OrgTypes WHERE OrganizationTypeID=target.[@field:Organization_type])
+'. '+(SELECT Description FROM _v_vw_360OrgTypes WHERE OrganizationTypeID=target.[@field:Organization_type])
Are there other expressions to modify the texts? Anywhere I can find examples?
Appreciate any input!
/Gunnar
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.