• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

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
 


 
0
MarcosStudent
Asked:
MarcosStudent
1 Solution
 
QPRCommented:
SELECT *

FROM EMPLOYEEADDRESSTABLE

WHERE LASTNAME LIKE 'S%' or LASTNAME LIKE 'J%'
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now