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

Scott Dexter sgd at ti3.com
Thu Nov 29 13:47:44 CST 2001

> 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

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

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


More information about the thelist mailing list