Posted by SQL Learner on 01/22/07 19:24

Hi Alan,

Thank you again for your help. I just posted the same question in the
Access group 1 hour ago.

Let's assume in Access (or SQL Server), the text and number can be
concatenated. Could you change your current code for me based on that
assumption?

Also, I thought the old code

SELECT t.* FROM tblStreet t WHERE EXISTS(SELECT 1 FROM tblWord w WHERE
t.Street LIKE '%'+Word+'%')

can be used for the new one?

- Grasshopper -

[Back to original message]