Thursday, October 11, 2012

Returns the first five characters from a zip code

Returns the first five characters from a zip code
 --Derived Column Transform in the Data Flow:
SUBSTRING(ZipCodePlus4,1,5)

No comments:

Post a Comment