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

Correct SQL syntax

I need the correct SQL syntax to find any records that contain a certain text.  For example, if table "customers" has a field "address", I would need the syntax to recover any record that has "800" in the address line.  One example result would be the address: 800 Main Street.
0
GDTRFBtoo
Asked:
GDTRFBtoo
  • 2
1 Solution
 
dqmqCommented:
Select * from customers where address like "%800%"
0
 
dqmqCommented:
Correction:
Select * from customers where address like '%800%'
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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