Filter out NULLS

[mrdaytrade]

I would like to run this report, but have it only show the results if a value is present in dbo.tblRegistry.Value


Select Distinct Top (1000000) dbo.tblComputers.Computer,
dbo.tblComputers.Description, dbo.tblComputers.Username, dbo.tblRegistry.Value
As [Search Box], dbo.tblRegistry.Lastchanged, dbo.tblComputers.LastknownIP
From dbo.tblRegistry Inner Join
dbo.tblComputers On dbo.tblComputers.Computername =
dbo.tblRegistry.Computername
Where
dbo.tblRegistry.Regkey Like
N'HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters'


Thanks in advance.

[Hemoco]

Try this:

Select Distinct Top (1000000) dbo.tblComputers.Computer,
  dbo.tblComputers.Description, dbo.tblComputers.Username, dbo.tblRegistry.Value
  As [Search Box], dbo.tblRegistry.Lastchanged, dbo.tblComputers.LastknownIP
From dbo.tblRegistry Inner Join                     
  dbo.tblComputers On dbo.tblComputers.Computername =
    dbo.tblRegistry.Computername
Where (dbo.tblRegistry.Value <> '' And Not dbo.tblRegistry.Value Is Null) And
  dbo.tblRegistry.Regkey Like
  N'HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters'