I have generated a SQL string like below:

SELECT * FROM opportunity, codes WHERE opportunity.TypeCode = codes.TypeCode AND opportunity.TypeCode LIKE 'I-A%' OR opportunity.TypeCode LIKE ' II-A %'

Can anyone see why the SQL is only returning the values associated with the first LIKE statement and not the second as well?

thanks,

Erik

Dear Erik,

SELECT * FROM opportunity, codes WHERE opportunity.TypeCode = codes.TypeCode AND (opportunity.TypeCode LIKE 'I-A%' OR opportunity.TypeCode LIKE ' II-A %')

Regards,
Brent

Hi Brent:

I add the ( )'s
(opportunity.TypeCode LIKE 'I-A%' OR opportunity.TypeCode LIKE ' II-A %')

But results still only come back for the first LIKE statement. have any ideas?
[
quote]
Dear Erik,

SELECT * FROM opportunity, codes WHERE opportunity.TypeCode = codes.TypeCode AND (opportunity.TypeCode LIKE 'I-A%' OR opportunity.TypeCode LIKE ' II-A %')

Regards,
Brent

Dear Erik,
Then your data does not match the query - also, you don't have spaces in this:

' II-A %'

like you do in your post?

Regards,
Brent

Thanks Brent:

It was the space. Good eyes!