CODEWITHSUNDEEP
sql-server-2008null
asma
asma

Reputation: 2825

How to remove null rows from sql query result?

I have a SQL query in which I am getting some records. Query is:

    select c.Id, c.FirstName, dbo.GetClientStaffContacts(c.Id, '27,31') as Staff from Client c order by c.Id

Result is: enter image description here

I want only those rows that are not having null values in column Staff.

Any help would be appreciated. Thank you.

Upvotes: 9

Views: 47610

Answers (1)

heximal
heximal

Reputation: 10517

select 
  c.Id, c.FirstName, dbo.GetClientStaffContacts(c.Id, '27,31') as Staff 
from 
  Client c 
where
  dbo.GetClientStaffContacts(c.Id, '27,31') is not null
order 
  by c.Id

Upvotes: 18

Related Questions