Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Empty string for default on a char field
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00482602
Message ID:
00482640
Views:
11
I'm not seeing what your seeing. This is what I did:

create table x (c varchar(10) default '')
insert into x default values

select datalength(c) from x -- returns 0
select c+'hello world' from x -- returns 'helloworld'

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform