Try this. If it works fine, make it a UDF and call it passing in your name field.

declare

@Input varchar(200)

,@Delimiter varchar(5)

,@Output varchar(150)

set @Input = 'Doe, John'

set @Delimiter = ','

WHILE LEN(@Input) > 0

BEGIN

IF CHARINDEX(@Delimiter, @Input) > 0

BEGIN

SET @Output = SUBSTRING(@Input,0,CHARINDEX(@Delimiter, @Input)) + @Delimiter + ISNULL(@Output,'')

SET @Input = SUBSTRING(@Input,CHARINDEX(@Delimiter, @Input)+1,LEN(@Input))

END

ELSE

BEGIN

SET @Output = @Input + ' ' + ISNULL(@Output,'')

SET @Input = ''

END

END

print SUBSTRING(@Output,0,LEN(@Output))

Mark