sql server 2000 problem in inserting varchar value into a varchar colu 1

[tempo1]

hi everyone,
i created a table with a varchar column and when i tried to insert value into it as follows:

declare @xxx table
(
aaa varchar
)
 
INSERT INTO @xxx
(    
aaa    
)   
SELECT   
cast(333 as varchar)

i recieved the following error message:

String or binary data would be truncated.
The statement has been terminated.

can anyone tell me why ?
thanks.

 

[gmmastros]

Try...

declare @xxx table
(
aaa varchar[!](30)[/!]
)

You should always specify the size of varchar columns.

-George

"the screen with the little boxes in the window." - Moron

 

[tempo1]

Thanks a lot.