Can I fix this in my setup options?

jeffsturgeon2002jeffsturgeon2002 Posts: 10
edited June 26, 2008 4:53PM in SQL Refactor Previous Versions
SQL Refactor first off looks like it will save me hours of tedious work. I purchased SQL Prompt and love it.

I am demo testing Refactor to see if its something I may wish to purchase.

My code is getting set like this:
'120.Insured1Zip' = CASE WHEN COALESCE(pi.InsuredSameAsPatient,
                                                       1) = 1 THEN pp.zip
                                         WHEN COALESCE(pi.InsuredSameAsGuarantor,
                                                       1) = 1 THEN g.zip
                                         ELSE ISNULL(pi.zip, '')
                                    END,

I want it to look like this:
'120.Insured1Zip' = CASE WHEN COALESCE(pi.InsuredSameAsPatient,1) = 1 THEN pp.zip
                                         WHEN COALESCE(pi.InsuredSameAsGuarantor,1) = 1 THEN g.zip
                                         ELSE ISNULL(pi.zip, '')
                                    END,

Its taking the value after the comma and forcing it to another line. Any help is appreciated. Maybe I just overlooked something obvious.

Comments

Sign In or Register to comment.