Concatenate, how to TRIM blank spaces

[Tarak]

Hi all,

I'm just created a new label and and connected to an SQL database, I used the concatenate function to join 2 fields, but in the preview it looks like this: 654 A (it's actually got about 10 spaces in between, but I couldn't show that here, it would only let 1 space show), how can I trim these fields so it looks like this: 654 A?

Can the blank spaces be removed easily, or does it need to be done in SQL?

The SQL section displays this (not sure if this helps) :

SELECT [jmpJobID], [jmpPartID], [jmpPartRevisionID], [jmpPartShortDescription], [jmpOrderQuantity], [jmpPartWareHouseLocationID], [jmpPartBinID]
FROM [dbo].[Jobs]
WHERE [jmpClosed] = 0
ORDER BY [jmpJobID]

[Kyleodonnell]

Tarak,

You would need to use scripting in order to remove the spaces in the database field, you can something like the Right function. You can also just remove spaces in the data which would be easier