Example :-
UPDATE dbo.Tbl_Employee
SET LastName =
(
CASE WHEN (DepartmentName = 'EDP') THEN FirstName+ '-'+ LastName
ELSE (LastName+ '.'+ FirstName)
END
)
Ad
Search This Blog
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment