Blank default values for varchar field

[hertz_j]

Hi I want to use a blank (empty string but not null) as a default value for varchar column in SQL server 2000. Is this possible and if it is, how do I do it (in Enterprise Manager if possible)? Just so that I don’t get a lot of why do you want to do that answers. The underlying data access layer I use need blank values or it won’t create a correct xml files. Thanks Johan

[Ramya SM]

Simply use "Create table Table1(col1 int, col2 varchar default ' ') Ramya -- modified at 5:53 Friday 12th May, 2006

[Eric Dahlvang]

hertz_j wrote:

in Enterprise Manager if possible)

In the Columns Property Page put SPACE(0) as the Default Value. ---------- There go my people. I must find out where they are going so I can lead them. - Alexander Ledru-Rollin

[hertz_j]

Hi Eric, I'll try that, thank you.