Hi Pedro,

Alter Table Table1 ;
  Alter Column Field1 Set Default "-";
  Alter Column Field2 Set Default "-"

Liam


>Hi
>
>i need alter one table , for each field caracter , if want if this field is empty then this field = "-"
>
>i think that , i can use ALTER TABLE ... DEFAULT ,
>
>but i don´t know how use this .
>Can you help me ?
>
>Example : i have this table Table1
>
>Field1 Field2
>Peter
> Brazil
>
>
>
>i want this
>
>
>Field1 Field2
>Peter -
>- Brazil
>
>
>yes , i know that i can make a lot of replaces ...
>but i think is more easy if i make
>
>

>FOR gnCount = 1 TO FCOUNT( )
>	IF Type(FIELD(gnCount) ) = "C"
>		 ALTER TABLE TEMP ;
>		ALTER COLUMN FIELD(gnCount) DEFAULT "-" && how can i do this?
>	ENDIF	
>NEXT
>
>

>
>Thanks