Get the non empty data from a sql_varient column

156 Views Asked by At

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

3

There are 3 best solutions below

0
On BEST ANSWER

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
1
On

I think you want this.

you can try it

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

Try this one:

  SELECT * FROM Table Where sql_varient_column != ''