sql2000 select question

[wiki]

sql2000:

Score_BD Table:

A   B	C   D	E	F    G	   H     I	K	L
-   -	-   -	-	-    -	   -     -	-	-	
9   1	3   30	5	     9	  3			
9   1	6   50	5	     9	  3
9   1	99  40	5	8    9	  3     7	6	3
9   1	66  21	5	7    9	  32    7	6	3
9   1	44  19	5	9   10	  37    7	6	3
10  1	50  20	5	     9	  3			
10  1	49  20	5	     9	  3
10  1	48  20	5	8    9	  3     7	6	3
10  1	47  21	5	7    9	  33    7	6	3
10  1	46  19	5	9   10	  34    7	6	3

need to extract:
G and H columns case when F is not null and A is 10.

[wildfrog]

Something like:

SELECT G, H 
FROM Score_BD 
WHERE F IS NOT NULL AND A = 10

- petter

[antares686]

Or if you prefer that if either condition is met as opposed to both use

SELECT G, H
FROM Score_BD
WHERE F IS NOT NULL OR A = 10

[Krzemo]

Or if you prefer that if either condition is met as opposed to both use

Or if you prefer that if first condition is met as opposed to previous solutions

 SELECT G, H 
FROM Score_BD 
WHERE F IS NOT NULL