SQL simple query

try:

select * from yourTable where column4 is not null and column6 is not null

Tried that but it still gives me rows with NULL i both columns

>>Tried that but it still gives me rows with NULL i both columns
are you sure that?

if you got blank values in one of those columns, it's a blank value NOT a NULL value.

do you want to return those records with blank values in either column4 or column6 ?

If there is a NULL value in both 4 and 6 I don't want it returned

>>If there is a NULL value in both 4 and 6 I don't want it returned

so both must be not NULL, if yes, then try my previous posted SQL:

select * from yourTable where column4 is not null AND column6 is not null

IF either column4 or column6 contains NULL value and want to exclude them, try:

select * from yourTable where column4 is not null OR column6 is not null

I ran this query:

SELECT [ID]
      ,[Fornavn]
      ,[Efternavn]
      ,[Initialer]
      ,[Løn Nummer]
      ,[Kortnummer]
      ,[GammelIDKort]
  FROM [Cardexchange].[dbo].[users]
  WHERE ('Løn nummer' IS NOT NULL) AND ('GammelIDKort' IS NOT NULL)

Select allOpen in new window

And I get the following returned:

Vikas is correct on that.

'Løn nummer' would be referring to a char value, NOT referring to a field name.

:)

'Løn nummer' is a string
[Løn nummer] or "Løn nummer" refers to the column

as an observation, it seems that Ryan Chong provided the correct advice yet is unrewarded