Set Exact not behaving 1

[audiopro]

I am attempting to create a fairly complex query but I am bogged down with some simple syntax.
Why is the following pulling D114, D114A, D114B etc. and anything else starting with D114 from the table?

SET EXACT ON
select code, qty, each;
from dda;
where code="D114"

I want the occurences of exactly "D114" only.

Keith

http://www.studiosoft.co.uk

 

[Olaf Doschke]

for SQL there is SET ANSI ON...

Bye, Olaf.

 

[audiopro]

Thanks Olaf


Keith

http://www.studiosoft.co.uk

 

[TamarGranor]

Rather than using SET ANSI, in a case like this, you'd be better off using the == operator:

select code, qty, each;
from dda;
where code=="D114"

That way, you won't change the behavior of any code outside this query.

Tamar