T-SQL Return True / False based on Is Null

So I’m working on a project where images are uploaded to a database table. The table has an image column, and if there is no image, then the column is just null,  but otherwise the bytes for the image are stored.
An ASPX page takes in the row id for this table via querystring and serves up the [...]