1 Replies - 4384 Views - Last Post: 11 June 2006 - 10:10 AM Rate Topic: -----

#1 ross_petersen  Icon User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 65
  • Joined: 06-August 05

Zero Length String in SQL Server

Posted 11 June 2006 - 12:29 AM

HI folks

I have a table called clients that has a number of fields that I would prefer not to have NULL entries in.

Uisng Enterprise Manager, how do I establish a zero length string as the default for those fields?

Kind regards

Ross :)
Is This A Good Question/Topic? 0
  • +

Replies To: Zero Length String in SQL Server

#2 Amadeus  Icon User is offline

  • g+ + -o drink whiskey.cpp
  • member icon

Reputation: 248
  • View blog
  • Posts: 13,507
  • Joined: 12-July 02

Re: Zero Length String in SQL Server

Posted 11 June 2006 - 10:10 AM

Any number of ways...the easiest is likely to have the column as type texh or varchar, and default the entry to ""...that is, a quote followed immediately by another.

I'd be remiss, however, if I did not point out that this will not give you any functionality that a NULL value will not...
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1