My question is I have a fixed width file which is loading an empty string into my varchar columns when no data is present while I want these to load as null. I can't find a way to control this load behavior. Using modified by striptblanks has taken the data down from a x length string for varchar(x) to a zero length string, but this doesn't meet the is null predicate.
TIA Rita - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
