Software

Ask something
Question Locked

MS Access string matching

0 helpful
3 replies

by jonathan.krisda

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

I having problem writing SQL, I need compare string(keyword field) with other fields, such as product description filed and product title field. The result will show every product that have a description or title that matches a keyword.

In keyword field, there are many words in them and I need to compare each of them with the description field and title field in one go.

Could, anyone, please help me!

Thank you.

3 replies

by amityksharma

select * from tablename where Columnname like '*'+'value'+'*'
Enjoy................................

This discussion is closed to new replies.