Previous Discussion	Next Discussion

Why Won't This Query Work??? I ran these queries in the MS SQL Query Analyzer. The first query is suppose to return the same data that the second query returns. Is the first query's syntax correct? Please advise. Thanks! SELECT LastName, FirstName, MiddleI FROM tbl_Passwords WHERE  (UserID = 'X') AND (Password = 'Z') LastName                  FirstName                 MiddleI ------------------------- ------------------------- ------- (0 row(s) affected)   SELECT LastName, FirstName, MiddleI FROM   tbl_Passwords WHERE  (UserID = 'X') OR (Password = 'Z') LastName                  FirstName                 MiddleI ------------------------- ------------------------- ------- Littleton                    Henry                     F (1 row(s) affected)   Started By tomterrific on Jan 31, 2007 at 10:45:33 AM

1 Response(s) | Reply

Earlier Replies | Replies 1 to 1 of 1 | Later Replies

BachusII on Jan 31, 2007 at 11:09:10 AM (# 1) Passwords are usually stored in an encoded form. Password = CRYPT( 'Z' ) for example.

Earlier Replies | Replies 1 to 1 of 1 | Later Replies

To respond to a discussion, you must first logon.

If you are not registered, please register yourself to become a member of the SiteExperts.community.