is there anysql equivalent to inner join ins on ins.address like '%a%'

[kkshansid]

SELECT [TOWN].*, institute.addre ss
FROM [TOWN] inner join institute on institute.addre ss like '%[TOWN].town%';

[orangeCat]

kkshansid,
There is NO join with a Like operator. However, there is a WHERE clause that can use Like

Here is an example:
SELECT *
FROM tblCustomers
WHERE [Last Name] LIKE 'W*'


Here is m$oft website re: SQL

http://msdn.microsoft.com/en-us/library/aa140011%28office.10%29.aspx#acfundsql_dml