- Moderator
- #1
Here's a simple one.
I have a table that I'm bouncing a query off of.
One of the fields is a "Bit"
In my query, I'd like it to return a "Yes" or a "No" instead of a -1 or a 0.
Something like "SELECT thebitfield AS strYesNo FROM thetable"
You get the idea... any thoughts? Thanks!
Just my 2¢
"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."
--Greg
I have a table that I'm bouncing a query off of.
One of the fields is a "Bit"
In my query, I'd like it to return a "Yes" or a "No" instead of a -1 or a 0.
Something like "SELECT thebitfield AS strYesNo FROM thetable"
You get the idea... any thoughts? Thanks!
Just my 2¢
"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."
--Greg