SQL Proboblem/Bug

[RwGast]

How would you run a WHERE on 17' monitors? <br>LIKE SELECT * FROM tblTable WHERE fldPRoducts = '17' monitors' SQL doesnt likt the single quaote. Is there an escape sequence like \' or something?

[Paul]

&' i think...

[RICoder]

Did you try double quotes?<br><br>"17' Monitor"<br><br>Depends on the implimentation of SQL, and I never tried it on a PPC.

[RwGast]

Ok heres the deal &' doesnt work i get this error<br><br>Query:<br>select * from CCIProducts where pdctProductCode LIKE '&''<br><br>Error:<br>Server: Msg 105, Level 15, State 1, Line 1<br>Unclosed quotation mark before the character string '&'<br>'.<br>Server: Msg 170, Level 15, State 1, Line 1<br>Line 1: Incorrect syntax near '&'<br>'.<br><br>I tried to use double quotes with  the where attribute and it didnt work<br><br>Query:<br>select * from CCIProducts where pdctProductCode LIKE "memory"<br><br>Error:<br>Server: Msg 207, Level 16, State 3, Line 1<br>Invalid column name 'memory'.<br><br>I am using Microsoft SQL server 7.0 with Visual Basic and ADO, This has nothing to do with the ppc RICoder. I ran all thoughs Querys in the SQL Quey Analizyer to make sure there was no middle man problem with VB and ADO.<br><br>So does anyone know how to do a querly like<br><br>SELECT * FROM CCIProducts WHERE pdctProductCode = '17' monitor'<br><br>The problem is sql thinks im termanating my query at the ' after 17. I know there has to be a way of doing this i just dont know how. <br><br>Any help would be qreatly appriciated becuase this is for my job, thanks.

[RICoder]

ADO is funky like that.  Mostly it requires strict adherence to STANDARD SQL.  Meaning that you need to do stuff like using % as a wild card, even though some DBs use *.  But, in other cases it doesn't care what you do, like you can use a terminating ; in the statement, even though only Access (that I know of) lets you do that.  This is all fluff, but I wrote it anyway.<br><br>My point is, I guess, that standard SQL uses ' as string literal containers, NOT ".  In fact the " will raise an error in some cases in ADO.  It ALWAYS did for me when I tried to write some test code.<br><br>I don't know if there are any escape sequences in SQL...and I won't be in my office to ask our resident SQL guru until Thurs...If you still want to know then, let me know.

[RwGast]

ok, ill let you know i think i may be talking to a guy today.

[Mr Visitor]

Try two single quotes e.g. ''  That works on 'Big' SQL

[Mr Visitor]

[Mr Visitor]

[Mr Visitor]

[Mr Visitor]

[RwGast]