Am using a non MS language that doesn't recognise the concept of NULL or EMPTY fields.

When I update the table, standard ODBC connection, it writes NULL into the table fields for any variable that doesn't have a value.

Is it possible to send a character string/ESC sequence to MS SQL telling it to insert an EMPTY field rather than a NULL field?

Am unable to touch the actual SQL database, i.e provide a trigger, as it's not ours to modify.