Select query Null

Question

I am working with SQL Server 2008 and have a select query that I am trying to create a Null column in.

The query is being used to create a tab delimited text file to be imported by a different system. I am using

Select data1 as col1, data2 as col2, '' as col3, data4 as col4

The problem apparently is that the other system does not see Col3 as NULL even though when I open it in Notepad++ it shows a NULL in that column. The vendor says there is something in that column. I assume they are seeing it as an empty string and not null.

What is a different/better way to put that NULL column in?

Thanks,

Mikhail Timofeev · Accepted Answer · 2013-10-31 14:32:36Z

2

Select data1 as col1, data2 as col2, NULL as col3, data4 as col4 FROM tamble_name

answered Oct 31, 2013 at 14:32

Mikhail Timofeev

2,16916 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

DragonRider Over a year ago

We tried the "NULL" as col before and they said no, hence we went with empty string/null This is what I just received from them.. They said there was specific characteristic NULL code with 1 byte. Are there any ways to put really “Nothing” (0byte) in place of that NULL code with 1 byte ?

Tim Schmelter Over a year ago

@user2941811: Don't use 'NULL'" but NULL. NULL means undefined as opposed to an empty string '' or the string 'NULL' which are clearly defined.

Collectives™ on Stack Overflow

Select query Null

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related