Neil Thompson
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER