[thelist] trimming db output (was: ASP question: Req...)
rudy
r937 at interlog.com
Thu Nov 29 19:05:41 CST 2001
> From my experience, SQL won't
> allow implicit data conversions. Isn't this so?
you're speaking of microsoft sql/server? i prefer to use "sql" only when
speaking of the standard language, not a vendor-specific database
implementation of it
furthermore, sql/server isn't enough, 'cause it might refer to sybase's
product
so whenever there's doubt, i always try to remember to say "ms sql/server"
as to your question, sure, ms sql/server allows implicit data conversions
it does, for instance, on date calculations -- '2001-11-29' + 2 days
all dates are implicitly converted to a julian day number
but i digress...
i don't have access to ms sql/server, but i would expect a null
concatenated to any string, empty or not, to still produce a null result
this isn't a data conversion, though -- it's the way nulls behave
rudy
More information about the thelist
mailing list