[thelist] trimming db output (was: ASP question: Req...)

[Scott Dexter]

> 
> True, if you are interested in the value "NULL". This would 
> destroy that. 

no, it would cause a type mismatch error, so you gotta take it into
account and work around it.

appending with an empty string would work, but why not let the db do the
work:

Select ISNULL('n/a', Department) as Department from ...

(this is MS SQL Server; check your db's documentation to see if you have
it)


sgd