Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JoeMiller
Starting Member
2 Posts |
 Posted - 2008-04-01 : 07:08:17
|
Hi,A really basic problem in psuedo code...select * from mytable where email = 'test@go.com' This throws back:Unclosed quotation mark before the character string 'test@'.Line 1: Incorrect syntax near 'test@'.Unclosed quotation mark before the character string ''. Because of the 'go'. Other addresses featuring 'go' suffer the same problem. How do I escape it?Thanks,Joe |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-01 : 07:14:06
|
Works for me, but I am using SSMS connected to a SQL Server 2000 Standard SP4.What is your setting for quoted identifier?SET QUOTED_IDENTIFIER { ON | OFF }
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-04-01 : 07:16:47
|
Don't see why as this works for me.declare @t table (a varchar(20))insert into @tselect 'test@go.com'select * from @t where a = 'test@go.com' |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-04-01 : 07:17:59
|
Bah, Pesos quick off the mark today.  |
|
|
|
JoeMiller
Starting Member
2 Posts |
Posted - 2008-04-01 : 19:13:03
|
| Strangely, it works fine in MS Query Analyzer, but I was using Query Express. I'll send this to the QE author, just in case... |
|
|
|
|
|
|
'Go' keyword being interpreted in literal