CASE WHEN [IS_SHADOW] = 'Y' THEN S_ACCOUNT_E30.ACCOUNT_NUMBER = '7%' else S_ACCOUNT_E30.ACCOUNT_NUMBER END

[enter image description here]

1CASE WHEN [IS_SHADOW] = 'Y' THEN S_ACCOUNT_E30.ACCOUNT_NUMBER = '7%' else S_ACCOUNT_E30.ACCOUNT_NUMBER END