How to set a Default Value

Hi

I have created a column item varchar(11) with default
value = 0

But when i do insert any record the value is set to
null.

How can i always get the defualt value if any other
value is not defined (sometimes it will have some
identification characters)

Thank´s in advance

Ângelo Marcos Rigo
AMR Informática
(51) 3348 0870
Rua Pe. Alois Kades 400/210
Porto Alegre /RS/Brasil
http://amr.freezope.org
angelo_rigo@yahoo.com.br









_______________________________________________________
Yahoo! doce lar. Faça do Yahoo! sua homepage.
http://br.yahoo.com/homepageset.html