InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSun, 07 Sep 2008 10:51:08 GMT20http://www.teradata.com/teradataforum/Topic11344-1-1.aspxYou can't use case statement directly in the fastload script.It is possbile for you to embed INMOD into fastload to do such transfer job.Or you can use NULLIF in the define section. But with this method, the input field containing the specified value should be treated as NULL...Sat, 03 May 2008 23:35:06 GMTJianhttp://www.teradata.com/teradataforum/Topic11344-1-1.aspxHi All,Can we use CASE statement in a fastload script. I want to check for zero length string. Is it possible to use some thing like thisCASE(LENGTH(:input_string)=0) Then 'UNKNOWN' Else :input_stringPlease advise.Thanks,AmitFri, 02 May 2008 02:11:06 GMTamitaryans