Posted by tlyczko on 09/25/06 18:18

I have a char(11) for SSN, and I would like to default it to
123-45-6789 so I can avoid having nulls in this column, and so I can
easily find the rows in which I need to have a 'correct' SSN
entered/updated.

I tried using just 123-45-6789, and SQL2005 doesn't seem to be
defaulting to this value, it seems to be keeping it as
(((123)-(45))-(6789), and not placing it into this column when a new
row is created....

Is there some special way I must specify defaults for a char(11) field
(Yes, I will include the dashes).

Thank you,
Tom

• Next in forum: Re: set default value for a char column??
• Prev in forum: Re: what should i do when i want to save a select resultset,but not in a new table,in memory is the best?
• Thread view: set default value for a char column??

[Reply to this message]