SQL - Update Query with Case Condition
Posted on 2011-02-16
SQL 2008 / 2005
I am trying to update a Column with Conditions :- If the Column Value has 9 digits, then Add 2 Zeros on its Prefix, If the Column Value has 8 digits, then Add 3 zeros on its Prefix.
This is an Update Query, - I am not sure, how to fix this issue.