CODEWITHSUNDEEP
sql-servert-sqlescaping
BP_
BP_

Reputation: 2647

How to escape @ symbol in SQL WHERE Clause?

I'm trying to run something like this in Excel:

SELECT currency_id, period_id, date, price_1, price_2

FROM Prices

WHERE scenario_id='1' AND period_from='04/14/2014' AND period_to='04/14/2014'
 AND date='04/14/2014' AND date_time='04/14/2014' price_type='r@periodic'

How to escape @ symbol in SQL WHERE Clause?

I got "Incorrect syntax near 'price_type' error.

Upvotes: 0

Views: 261

Answers (2)

BP_
BP_

Reputation: 2647

AND operator was missing between date_time='04/14/2014' and price_type='r@periodic'

Upvotes: 2

mohan111
mohan111

Reputation: 8865

DECLARE @Bit VARCHAR(10) = 'r@period'
select REPLACE(@Bit,'@','')

Upvotes: 0

Related Questions