comments confuse reformat

[rbennet8]

consider this snippet.
@back_up_path varchar(500), -- path for backup directory
@log_path varchar(500), -- path for log directory
@JobID BINARY(16),
If you choose comma first, reformat changes it to
,@back_up_path VARCHAR(500)
, -- path for backup directory
@log_path VARCHAR(500)
, -- path for log directory
@JobID BINARY(16)
it should be reformatted as this
,@back_up_path varchar(500) -- path for backup directory
,@log_path varchar(500) -- path for log directory
,@JobID BINARY(16)

[Manfred.Castro]

Sorry you are experiencing this.
This is a known issue and there is an existing feature request to better handle comments in our uservoice forums you may want to vote for.
http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions/suggestions/1872709-moving-commas-from-end-to-start-is-always-bugg
These forums are monitored by our developers and allow our users to request features and vote on them.
If a request receives significant support the feature may be included in a future release.
_________________
Manfred Castro
Product Support
Red Gate Software