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

for example if the column is varchar it should be is not null — udaya726, Jun 15 '15 at 07:08
you mean like empty strings? (`''` is different then `null`) — Zohar Peled, Jun 15 '15 at 07:09

score 3 · Accepted Answer · answered Jun 15 '15 at 07:10

3

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

answered Jun 15 '15 at 07:10

Eric

score 2 · Answer 2 · answered Jun 15 '15 at 07:22

2

Try this one:

  SELECT * FROM Table Where sql_varient_column != ''

answered Jun 15 '15 at 07:22

User Learning

score 0 · Answer 3 · 2015-06-15T07:17:42.360

0

I think you want this.

you can try it

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

edited Jun 15 '15 at 07:17

answered Jun 15 '15 at 07:10

1

I think you misunderstood the question. Also, your last select statement will never produce any results. – Zohar Peled Jun 15 '15 at 07:13

3 Answers3