I have a "StudentNames" column in an sql table.
Each student in the table has atleast two names all in one column.
Assume that the following as studentNames.
StudentNames ------------- John Smith Joseph Smitter Johan Smittin
How can I use the LIKE statement to select
students with same first 3 letters of first name and
same first 3 letters of second name and possibly third name.
I mean a query in the lines of:
SELECT StudentNames FROM MyTable WHERE StudentNames LIKE 'joh%' and (substring(....'smi%')
The expected result should be
StudentNames ------------- John Smith Johan Smitten
Your Help is Very Much Appreciated