WorknHardr
asked on
SQL Stuff Remove Trailing Character?
I know how to remove a Leading char like so, just don't know how to remove a trailing char. Help...
Stuff ((
Select '; ' + d.name
From Departments d
From XML Path(''), elements), 1, 1, ' ')
as Depts
Stuff ((
Select '; ' + d.name
From Departments d
From XML Path(''), elements), 1, 1, ' ')
as Depts
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER