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