Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Why isn't TRIM() working?

SOLVED

Posted By sclifford over 3 years ago

Top Replies

Jay Converse Acumen over 3 years ago in reply to sclifford +2 verified

RTRIM

0 Jay Converse Acumen over 3 years ago

Because TRIM is not a SQL function.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sclifford over 3 years ago in reply to Jay Converse Acumen

Is there a SQL function that does the same thing? I'm trying to remove blank spaces
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
+1 Jay Converse Acumen over 3 years ago in reply to sclifford

verified answer

RTRIM
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 sclifford over 3 years ago in reply to Jay Converse Acumen

Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Erzsi_I over 3 years ago in reply to sclifford

Hi sclifford, if the below suggested answer helped, please do mark it as verified for the benefit of others in this forum. Thank you!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 SergeB over 3 years ago in reply to Jay Converse Acumen

TRIM is a MS SQL function since SQL 2017.

https://docs.microsoft.com/en-us/sql/t-sql/functions/trim-transact-sql?view=sql-server-ver15#:~:text=By%20default%2C%20the%20TRIM%20function,LTRIM(RTRIM(%40string))%20.

Before that version use LTRIM(RTRIM(ICITEM.ITEMNO)) as the UI allows for leading blank spaces for item numbers.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Why isn't TRIM() working?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING