While loop to check if data present (exists) in table in SQL Server

How to use while loop to check if data is present in sql table

How to create a function that will return true or false if SQL server table-specific column has data or not.

When there is null want to return false else return true