[transfer-dev] setting null values. What do ppl use for strings?

2009-02-11 Thread barry.b
these are for sentinal values so I can maintain nulls -1 for bool, Jan 1 100 for dates, etc. but if is a valid value, suggestions on a suitable value to represent NULL for a string? somehow [[BOOHOOHOO]] (or similar) doesn't quite rock my socks...

[transfer-dev] Re: setting null values. What do ppl use for strings?

2009-02-11 Thread barry.b
acesssable by users? On Feb 12, 7:23 am, barry.b barry.beat...@gmail.com wrote: @Bob we need to know whether a notes/comment field has ever had anything added since the record was first created (ie if it remains NULL). Empty string could hide something being added and later removed