Displaying Results

I am reading information from a sql db and would like for the information to display, which i had working, until i tried making it so that if there was no information in the db field, that it would not display any results. Here is a snippet of the code. Any thoughts.

if name <> "" then
Response.Write("Name: " & recordset("name")& "<br>")
end if

if company <> "" then
Response.Write("Company: " & recordset("company")& "<br>")
end if

if title <> "" then
Response.Write("Title: " & recordset("title")& "<br>")
end if