Query explanation request

[cleanair4me]

I am trying to figure out what the last part (firstname & '' = '') of the query in my Access 2000 SQL is doing:

select * from tableOne where firstname <> ''
and firstname & '' = ''

Please advise.

 

[PHV]

For me, this query should always return 0 row.
You wanted this ?
select * from tableOne where firstname is null

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JoeAtWork]

It looks like a very clumsy way of trying to find records where FirstName is Null (not to mention that it wouldn't work any ways).

I think PHV's SQL has the effect that the original author intended.

Joe Schwarz
Custom Software Developer

http://www.plandev.net