[thelist] trimming db output (was: ASP question: Req...)
Anthony Baratta
Anthony at Baratta.com
Thu Nov 29 14:05:06 CST 2001
At 11:48 AM 11/29/2001, you wrote:
> >
> > 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.
Strange, I've never had that problem. Of course now it will crop up! LOL
But using the isNull SQL Function is a total solution anyway. At work, I
usually am the one to harp on "let the database do the work", but I miss
stuff like this because most of my SQL needs are very basic.
Burning this solution into the grey matter for later use.
---
Anthony Baratta
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
More information about the thelist
mailing list