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

7.3.0.564 - Formatting Styles - CASE THEN expression

rickyhoffmannrickyhoffmann Posts: 2
edited September 30, 2016 6:40AM in SQL Prompt
Version: 7.3.0.564
Formatting: CASE THEN expression, -1 is up against the THEN (missing space)
Example:

SET [Force_Selected_With] = CASE
WHEN [bridge_Rule].[Rule_ProductItemID_Selected] = 1 THEN 1
WHEN [bridge_Rule].[Rule_ProductItemID_Selected] = 0 THEN-1
END

Thank you!

Comments

Sign In or Register to comment.