var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: re-arrange name data
i'm attempting to make a DTS package that will export to a csv each day. my problem is figuring out how to change a name field that stores the data as the following format:
First Middle Last
Last, First Middle in the outputted .csv file
thanks in advance.
substring(fld,len(fld) - charindex(' ',reverse(fld)),len(fld))
+ ', ' + left(fld,len(fld)-charindex(' ',reverse(fld)))
The numbers will be a bit wrong but you can fix that.