Yeah, I noticed on aspdb's webisite they use a type query like this:
select *
from mytable
where ssn like '%123%';

Which will find any ssn in my table that has 123 in it. Right?
for some reason this is not working in access 2000 any suggestions??

Thanks,

Kurt Meyers
kmeyer1@gl.umbc.edu