Sql Server Integration Services
Thursday, October 11, 2012
Remove a given character from a string
Remove a given character from a string
(ex. Remove "-" from a social security number)
Derived Column Transform in the Data Flow:
REPLACE(SocialSecurityNumber, "-","")
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment