
store chr(0) in database or microsoft binary file format
V>Hey all,
V>Is it possible to store chr(0) in a database ?
V>I have to export a table stored in a dbf format to microsoft binary
V>format. They tell me to pad the single precision integers with 4 times
V>chr(0).
V>Thanks,
V>mark t.
REPLACE fieldname WITH REPL(CHR(0),4)
Will store 4 nuls to a character field.
Brian Copeland