Zero-length character strings are changed to Null

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]

Posted by David Walker 75.146.141.142 on August 22 2008 12:32:54

In MS SQL Server, I have not checked the option to replace Nulls by empty quoted strings.

HOWEVER, I also do NOT want zero-length character fields from the source table to appear as NULL in the Insert statement. If the column in a table record contains NULL, I would like to see NULL in the Insert statement. If the column in a table record contains a zero-length character string, I would like to see '' in the Insert statement. Changing the zero-length string to NULL is not correct! They are different things.

Thanks! Great tool.

Follow Ups:

Re: Zero-length character strings are changed to Null - Dave 13:08:56 September 09 2008 (0)

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> In MS SQL Server, I have not checked the option to replace Nulls by empty quoted strings. > > HOWEVER, I also do NOT want zero-length character fields from the source table to appear as NULL in the Insert statement. If the column in a table record contains NULL, I would like to see NULL in the Insert statement. If the column in a table record contains a zero-length character string, I would like to see '' in the Insert statement. Changing the zero-length string to NULL is not correct! They are different things. > > Thanks! Great tool.

Optional Link URL:
Link Title:
Optional Image URL:

Enter the code shown :

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]