----SELECT DATABASE----
USE HIGHTECHNOLOGY
GO
----LIKE CLAUSE EXAMPLES----
----FINDS ANY VALUE THAT START WITH MA----
SELECT * FROM STUDENT_INFORMATION WHERE NAME LIKE 'MA%'
GO
---FINDS ANY VALUE THAT HAVE MA AT ANY WHERE IN NAME----
SELECT * FROM STUDENT_INFORMATION WHERE NAME LIKE '%MA%'
GO
----FINDS ANY VALUE THAT HAVE ATLEAST 4 CHARACTER AND START WITH MA----
SELECT * FROM STUDENT_INFORMATION WHERE NAME LIKE 'MA__%'
GO
----FINDS ANY VALUE THAT HAVE 3 CHARACTER AND START WITH J AND END WITH I----
SELECT * FROM STUDENT_INFORMATION WHERE NAME LIKE 'J_I'
GO