Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100

Say CUST Table contains records like:
CUSTNO CUSTNAME CUSTLOC
100 ABC SSS
200 XYZ
300 PQR
400 MNO WWW
500 CVV
-------------
-------------
Now write a query to retrieve all records with CUSTLOC no
data.

Question Posted / sharat

3 Answers
6836 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS ..

Answer / vineet chauhan

no you have to use IS keyword as:

SELECT * FROM CUST
WHERE CUSTLOC IS NULL

Is This Answer Correct ?

11 Yes

2 No

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS ..

Answer / madhuri tungal

In the CUSTLOC field the no data is represented by SPACES
but not by .... i.e NULL VALUE

Hence the query would be,

SELECT * FROM CUST WHERE CUSTLOC IS SPACES;

Is This Answer Correct ?

0 Yes

3 No

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS ..

Answer / sharat

EXEC SQL
SELECT * FROM CUST
WHERE CUSTLOC = NULL
END-EXEC.
Can anyone let me know whether the query coded above is right.

Is This Answer Correct ?

0 Yes

6 No

Post New Answer