>We are trying to insert blank fields rather than null values into a btrieve database. When we use an INSERT SQL statement and set the field = " " it still inserts a NULL value into the field. Any way to make the field blank rather than null? We have tried setting a variable = " " and then inserting the variable into the field and this didn't work either.
>
>Another accounting application is using the btrieve application, and it is bombing on the NULL fields.
>
>Thanks,
>Doug
Use NVL( ) to remove null values from calculations or operations where null values are not supported or are not relevant.
Look in the Help on NVL as I think you can use it in your SQL.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope