Hi!
Ivan Sammut wrote:
[...snip...]
Is there any sql command which can find defined text in specific fields.
For example I have a table with names like "Ivan Sammut" etc. Now I want to
create a statment which select all those records which contain the text
"Ivan" or those that contain the text "Sammut". Is there a way I can
achieve this with an SQL statement.
[...snip...]
Your posting might yield better results in a sql newsgroup, but anyway:
select
*
from
yourtable
where
firstfield like '%Ivan%'
or
secondfield like '%Ivan%'
or
firstfield like '%Sammut%'
or
secondfield like '%Sammut%'
;
You'll need to include every column you want to check into the where-clause.
It might be a good idea to split the search into multiple select-statements
in case you are searching for more words...