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]