Link to home
Start Free TrialLog in
Avatar of Neil Thompson
Neil ThompsonFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL 2012 - How to remove the last , from data

hi

I'm wondering how I can remove the last , (comma) in my data please?

At present I'm pulling address data over from another table using DTS and one part replaces line breaks with commas, unfortunately some records also appear to have a break at the end resulting in a final ,

Many thanks in advance
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Neil Thompson

ASKER

Brilliant. Many thanks once again Vitor