Does the SELECT statement return a value?

[LiLo]

Hi,

I am setting up a user login account database. It consists of a table containg ID, username and password attributes.

First,the database will be searched to see if such a user exists.
What happens if the SELECT statement doesnt find a match? Does it return a value to indicate that there is no record found?