[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to use backslash in SQL?

Posted on 2004-09-23
1
Medium Priority
?
758 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

829 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