SQL query not working?

Thread View: borland.public.intrabuilder.data.sql

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Jeffery Chow Wed, 11 Feb 1998 00:00

#46

Author: Jeffery Chow
Date: Wed, 11 Feb 1998 00:00

28 lines
1221 bytes

Hi, I have a table that contains the following columns:
<number StudentKey>  
<alpha "interview (y/n)"> (null or "yes")
<date "interview date">   (null or date)

I'm trying to find rows for a specific student who has an interview but
has not set an interview date. The query:

SELECT * FROM signups WHERE studentKey = 12345678 AND "interview (y/n)" \
IS NOT NULL AND "interview date" IS NULL

However, this query doesn't work at all! My test data:

StudentKey   "Interview (y/n)"   "Interview Date"
12345678	yes	       	    1/9/98
12345678	yes	
12345678		

No matter how I vary the query, I either get ALL the rows back, or none
of them. I've tried "WHERE "Interview (y/n)" LIKE '%yes%'" but that didn't
work either.

I'm using the trial version of IB, tables are paradox 7.

Does anyone know what I'm doing wrong?

Jeff

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads