how to add a field in existing table database

im facing some problem.i wantto add a single field with 15varchar but it
couldnt i have tried before it works fine but know it gives me message as
(Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
able to findout ecaxt solution need your suggestion with appropriate solutio
n.Hi
Look up the ALTER TABLE command in Books online or at
http://msdn.microsoft.com/library/d...asp?frame=true
and use the version:
ALTER TABLE MyTable ADD mycolumn verchar(15)
You may have to use an UPDATE statement afterwards to update the existing
data.
John
"shoeb" <shoeb@.discussions.microsoft.com> wrote in message
news:C3E6D6B8-2B0D-4F0F-AA3C-1F4DA38FCC04@.microsoft.com...
> im facing some problem.i wantto add a single field with 15varchar but it
> couldnt i have tried before it works fine but know it gives me message as
> (Ansi_Padding Off) i have fetch the regarding purticular message i couldnt
> able to findout ecaxt solution need your suggestion with appropriate
> solution.