I can not recreate your problem. The binary code for ABC is different from the binary code for ABCD.

HTH Mike

IF OBJECT_ID('TEMPDB..#TEST') > 0

 DROP TABLE #TEST

CREATE TABLE #TEST

(

 PK_Test int IDENTITY (1,1)...

Oracle’s RTRIM is propriety and does not match the RTRIM used in T-SQL.  If your data is being stored in Unicode then all characters are...

Add a group by to Bersileus's statement.

SELECT A.MANAGERID, A.EMPID, A.EMPNAME AS MANAGER,

B.EMPNAME AS STAFF_NAME, B.EMPID AS STAFF_ID FROM @EMP A INNER JOIN @EMP B ON A.EMPID = B.MANAGERID

GROUP BY...

Try using sp_helpIndex.

HTH Mike

use Northwind

EXEC sp_helpindex 'employees'

/*

Returns

LastName nonclustered located on PRIMARY LastName

PK_Employees clustered, unique, primary key located on PRIMARY EmployeeID

PostalCode nonclustered located on PRIMARY PostalCode

*/

Rob, Kenneth many thanks to both of you for your input.

Kenneth  "SQL is very non-prejudice and will give you an answer to exactly what you have asked, not what you...

Crystal are you sure that every column is the same? If you have a primary key then this is not possible as a primary key must be unique. If you...

Rob you are right and just when I was feeling so good about having one of the experts agree with me. While you are off playing in the sunshine I...

This article from http://www.sql-server-performance.com/transact_sql.asp states that SQL evaluates AND operators from left to right as they were written. Hey it came off the internet it must be true. Do...

You are right about SQL returning False when both conditions are False. Where can I find information on the optimizer changing the order of logical statements.

Mike

Please post your tables and an their relationship.

Thanks

Mike

Rob

Since SQL reads logical statements from left to right and stops the reading when it hits the first not true condition preventing a divide...

Rob forgot the NOT XOR logic sorry.  NOT XOR returns true when one and only one of the conditions is false.

NOT true XOR true returns...

Rob  "XOR" returns true if one and only one of the two conditions is true. "NOT XOR" returns true if one and only on of the conditions is false. When using XOR both statements...

When you say "a long time", how long is that, exactly

Dave I have been asking myself that question since Windows 3.x when MS started using the Message "IF your system stops...

Your code uses the getdate() funciton 6 times. You could DECLARE a token for the current date and time at the start of the function and then replace the 6...