Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Empty fields

Author  Topic 

sardinka
Posting Yak Master

142 Posts

Posted - 2004-10-06 : 13:22:25
I have a comment field with data or no data. The problem is when I transfer the data into AS400 if field is empty it translates to end of record, however in reality it is not. How do I fix this issue?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-06 : 14:22:33
Is the source data SQL Server? When you say no data, do you mean the value is NULL at the source or empty? Why not just put a value for this no data, then take it back out when the transfer is done at the AS400?

Tara
Go to Top of Page
   

- Advertisement -