What are the challenges you face when working across database platforms? Take the survey
Options

Formatting of an UPDATE Statement

00leel0000leel00 Posts: 1 New member
Is there a way to get the fields of an UPDATE statement to line up like they do with a SELECT statement?
e.g.
Current
UPDATE xxx
SET      Field_1 = 'Something'
            ,Short = 'Something'
            ,LongName = 'Something'

Desired
UPDATE xxx
SET      Field_1       = 'Something'
            ,Short          = 'Something'
            ,LongName = 'Something'

Answers

Sign In or Register to comment.