title: Delete ; symbol at string end (SQL)
body: <p>I have SQL script that gets roles and return string with list of roles</p>
  <p>Here is part of code</p>
  <pre><code>, ISNULL(SUBSTRING(
                                    (
                                        SELECT  ECBR.RoleName + ';' AS [text()]
                                        FROM [External].[vw_ExecutiveChangeByRole] ECBR
                                        WHERE ECBR.VendorExecutiveChangeId = ECH.VendorExecutiveChangeId
                                          AND (ECBR.IsCurrentOrPrior IS NULL OR ECBR.IsCurrentOrPrior = 1)
                                          AND ECBR.RecognizedWith = 'ML'
                                        ORDER BY ECBR.RoleId
                                        FOR XML PATH ('')
                                    ), 1, 1000), '')                                   AS RecognizedCurrentRoles
  </code></pre>
  <p>And now showing like <code>VP;Controller;</code></p>
  <p>How I can make this string without last<code>;</code>, just <code>VP;Controller</code></p>