What if there is no Field Value in a SELECT?

Databases
1

What happens if I run a query like this…

SELECT activation_code
FROM member
WHERE email = 'bob@mail.com'

…and there is a Bob record with said “e-mail”, however the “activation_code” is NULL?

Do I get a record back?

Debbie

2

Yes.

3

not to be overly critical, but why can’t you test stuff like this yourself?

no, seriously… testing stuff yourself is the best way to learn

and it’s usually faster than waiting hours and hours for your free help desk to respond

4

I did test it, and I feel uncertain as to what is going on…

no, seriously… testing stuff yourself is the best way to learn

and it’s usually faster than waiting hours and hours for your free help desk to respond

See above.

Debbie