[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