Re: How to search on a column without using LIKE?

Your idea with a separate table holding text reference and keywords is pretty efficient if you want to find all text references that contain a certain word.

If you only want to search one entry, or if you want to do a full table scan, you should consider the instr ()-function.

-- 
Martin Haltmayer