[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

How to use backslash in SQL?

Posted on 2004-09-23
1
Medium Priority
?
760 Views
Last Modified: 2010-05-18
Hi,

I have this query I am TRYING to write.

I get an error in sql query analyzer

SELECT * FROM tblName
where someColumn = 40
and os = windows\2000

that woudl be an example..

I get this as an error msg

Line 3: Incorrect syntax near '\'.

Must be some way to escape this??

-ws
0
Comment
Question by:Westside2004
1 Comment
 
LVL 6

Accepted Solution

by:
OlegP earned 500 total points
ID: 12140593
SELECT * FROM tblName
where someColumn = 40
and os = 'windows\2000'
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

591 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