Trying to use sql with LIKE and % and OR

HOW CAN I SELECT WITH LIKE and % wildcard and use or?

SELECT *

FROM EMPLOYEEADDRESSTABLE

WHERE ((LASTNAME (LIKE 'S%') or (LIKE 'J%'))

TABLE
Employee Address Table
 
SSN
 FirstName
 LastName
 Address
 City
 State
 
512687458
 Joe
 Smith
 83 First Street
 Howard
 Ohio
 
758420012
 Mary
 Scott
 842 Vine Ave.
 Losantiville
 Ohio
 
102254896
 Sam
 Jones
 33 Elm St.
 Paris
 New York
 
876512563
 Sarah
 Ackerman
 440 U.S. 110
 Upton
 Michigan
 


 
MarcosStudentAsked:
Who is Participating?
 
QPRConnect With a Mentor Commented:
SELECT *

FROM EMPLOYEEADDRESSTABLE

WHERE LASTNAME LIKE 'S%' or LASTNAME LIKE 'J%'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.