>If i create an ODBC connect and select data
>i get null values if the fields are not filled.
>
>How can i avoid this

I've never found a way to avoid it, but I use
SET NULLDISPLAY TO SPACE(5)
so the user just sees a blank field.

If I really need to get rid of it for some reason, I've done the following:

SELECT mytable
SCAN
IF ISNULL(theField)
REPLACE theField WITH ""
ENDIF
ENDSCAN

Or, if you can open the table exclusively you can use
ALTER TABLE mytable ALTER COLUMN theField NOT NULL

--Caren