White-space between two values
<p>I have a column as like given below</p>

<pre><code>EB.Liter+'L'+EB.CC+'cc'+'-ci'+EB.BlockType+EB.Cylinders+
         (
       EB.EngBoreIn+'x'+
        EB.EngStrokeIn+';'+
        EB.EngBoreMetric+'x'+
    EB.EngStrokeMetric
         ) as EngineBase
</code></pre>

<p>This pull data something like this</p>

<pre><code>1.3   L 1339    cc L 4 (2.87      x3.15      ;73.0      x80.0      )
</code></pre>

<p>but i am trying to get something like</p>

<pre><code>1.3L 1339cc -ci L4 (2.87x3.15; 73.0x80.0)
</code></pre>

<p>may anyone please suggest if possible</p>

<p>i have tried something like this.</p>

<pre><code>LTRIM(RTRIM(EB.Liter))+'L'+LTRIM(RTRIM(EB.CC))+'cc'+'-  
ci'+LTRIM(RTRIM(EB.BlockType))+LTRIM(RTRIM(EB.Cylinders))+
        + (
       LTRIM(RTRIM(EB.EngBoreIn))+'x'+
        LTRIM(RTRIM(EB.EngStrokeIn))+';'+
        LTRIM(RTRIM(EB.EngBoreMetric))+'x'+
    LTRIM(RTRIM(EB.EngStrokeMetric))
         ) as EBase
</code></pre>

<p>which get me result as below
    1.3L1339cc-ciL42.87x3.15;73.0x80.0</p>

<p>but correct output is as
    1.3L 1339cc -ciL4(2.87x3.15; 73.0x80.0)</p>