Get the non empty data from a sql_varient column

Question

I have a sql table with sql_varient column. I want to query the table to get the records which has value. I used following query

SELECT *
from Table
WHERE sql_varient_column IS NOT NULL

But its return the data which has no data also. How can I achieve this

Answer 1

To get the row for column sql_varient_column is not null and not empty:

SELECT *
from Table
WHERE NULLIF(sql_varient_column, '') IS NOT NULL

Answer 2

I think you want this.

you can try it

SELECT *
from Table
WHERE ISNULL(sql_varient_column,'') != ''

Answer 3

Try this one:

  SELECT * FROM Table Where sql_varient_column != ''