Solved

Correct SQL syntax

Posted on 2007-04-07
2
218 Views
Last Modified: 2010-03-19
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
Comment
Question by:GDTRFBtoo
  • 2
2 Comments
 
LVL 42

Expert Comment

by:dqmq
ID: 18871014
Select * from customers where address like "%800%"
0
 
LVL 42

Accepted Solution

by:
dqmq earned 500 total points
ID: 18871020
Correction:
Select * from customers where address like '%800%'
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql query 8 48
Using MERGE to UPDATE a third table 14 37
sql help 8 55
What's wrong with this T-SQL Foreign Key? 7 41
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question