I have a column that looks like this Open NULL R252 R253 NULL or Openid open r252 abc cde r253 ghi jkl I want to get rid of the blank openID in my query I try using IS NOT NULL but that doesnt work any help

Hi gissah, If you are using t-sql side than use this, WHERE Openid IS NOT NULL OR Openid <> '' If you are using SSRS side than use this, (to hide the column visibility tab under column properties) = IIf ( IsNothing ( Fields!Openid.Value ) OR Fields!Openid.Value = "", TRUE, FALSE ) Please let us know your feedback. Thanks KumarKG, MCTS

I am trying both t-sql and ssrs I have tried where openid is not null but stull get some few nulls I just tried = IIf ( IsNothing ( Fields!Openid.Value ) OR Fields!Openid.Value = "", TRUE, FALSE ) and am getting true or false in the column

Hi gissah, try this t-sql query, CREATE TABLE #TEMP ( Openid VARCHAR(10) NULL, Op VARCHAR(10) NULL ) INSERT INTO #TEMP VALUES ('r252', 'abc') INSERT INTO #TEMP VALUES ('', 'cde') INSERT INTO #TEMP VALUES ('r253', 'ghi') INSERT INTO #TEMP VALUES ('', 'ghi') INSERT INTO #TEMP VALUES (NULL, 'uvw') SELECT Openid, Op FROM #TEMP WHERE Openid IS NOT NULL AND Openid <> '' DROP TABLE #TEMP Please let us know your feedback. Thanks KumarKG, MCTS

I am using a query builder and therefore cannot create the table

I'm just showing an example, please see my "WHERE CLAUSE":- WHERE Openid IS NOT NULL AND Openid <> '' You need to do something like this in your t-sql query. Does this makes sense? Thanks KumarKG, MCTS

yea I tried WHERE (Type NOT IN ('Siu-ai', 'Subrogation', 'Siu-fi', 'SIU', 'Siu-mi')) AND (Company = 'xxx') AND ([Compliant Status] = 'xxxxx') AND ([Reopen ID] IS NOT NULL) AND ([Reopen ID] <> '') OR (Company = 'xxxxx')

Can you try with this, WHERE ( Type NOT IN ('Siu-ai', 'Subrogation', 'Siu-fi', 'SIU', 'Siu-mi') ) AND (Company = 'xxx') AND ([Compliant Status] = 'xxxxx') AND (([Reopen ID] IS NOT NULL) AND ([Reopen ID] <> '')) OR (Company = 'xxxxx') Thanks KumarKG, MCTS

it work fine in ssms, but does not work in ssrs query builder. I am sorry

It should work in both of them.... Double check it you might be doing some wrong in "Query Builder" Thanks KumarKG, MCTS