multiple field statment  
Author Message
GeorgeBell





PostPosted: Fri Oct 08 15:02:25 CDT 2004 Top

SQL Server >> multiple field statment

I have a table that has 9 fields.
in some cases a record may almost be a duplicate of another record except
for one of the fields.


so I was thinking I need to write a statment to where I have to say what
each field equals, but I haven't had any luck

here is what I tried.


Select * from MyTable where field1 = "this" and field2 = "a" and field3 =
"test"


How do I write that statement correctly??

Thanks

SQL Server125  
 
 
David





PostPosted: Fri Oct 08 15:02:25 CDT 2004 Top

SQL Server >> multiple field statment Replace " with '. SQL uses a single quote to delimit literal strings rather
than a double quote. If that doesn't solve your problem then please tell us
exactly the wording of any error message you are getting.

--
David Portas
SQL Server MVP
--