Click here to Skip to main content
Search within:



Next

SSIS - Derived Columns
Sign Up to vote bad
good
See more: SQL2000SQL2005SQLSQL-Server, +
Hi,
 
I have one small question, I am new so please help me.
 
In my project I have one text file which has zip4 and zip5 , I want to concatenate both the zip code but it has one problem, at some place zip4 is blank (not null) so when I used the derived column with ISNULL(ZIP_4) ? ZIP_5 : (ZIP_5 + "-" + ZIP_4) expression it will return the (zip5-) where zip4 is blank and I want only zip5 without - .
 
So please help me.
Posted 5 Sep '12 - 7:31
Member 9362521332
Add a Solution


1 solution

What data type is ZIP_4? Could it be a string type, which case you would want to count the number of characters with LEN().
  Permalink  
Posted 24 Sep '12 - 12:10
S Douglas9.1K
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 414
1 Arun Vasu 253
2 OriginalGriff 200
3 CPallini 163
4 Aarti Meswania 158
0 Sergey Alexandrovich Kryukov 10,169
1 OriginalGriff 7,749
2 CPallini 4,181
3 Rohan Leuva 3,482
4 Maciej Los 3,089


Advertise | Privacy | Mobile
Web01 | 2.6.130523.1 | Last Updated 24 Sep 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid