concatenate question 1

[Palmyra]

select old_case,
old_case + SUBSTRING(reference_text, 5, LEN(reference_text))+ '0' AS 'Matter' ,
reference_text
FROM...

is returning

old_case Matter reference_text
F1234- F1234-0147 0 207-0147

instead of the desired


old_case Matter reference_text
F1234- F1234-01470 207-0147

I guess I have spaces I need to strip before I concatenate the '0'

Can someone help?

Thanks.

 

[djj55]

You might what to try

SUBSTRING(reference_text, 5, LEN(reference_text)[red]-5[/red])

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[Palmyra]

Thank you!