Yiu should rethink your design and store languages in normalized form

-- Table LanguageLookup
LanguageID Language
1          English
2          Fench
3          Chinese
4          Spanish
...
-- Table  Languages 
ApplicantId LanguageID
1           1
1           2
1           3
2           1
2           2
2           4
...

>I have developed a recruitment Software,where in Resumes are entered and searched as per the job criteria.
>There is a field in Applicant Table called Languages which holds the languages known by applicant.
>Example

>Applicant Id,                    Languages
>1,                               English,French,Chinese
>2,                               Spanish,English,French
>3,                               French,English,Russian
>4,                               German,Latin,French,Russian
>5,                               Hebrew,Arabic
>6,                               Chinese,English

>
>Now lets say I have the above records in my table and i want to search for Applicants who know English & French
>So my query result must be
>
>Applicant Id
>1
>2
>3
>
>Can you'll suggest what can be the SQL statement for this result set.
>
>Thanx