I've used the COLLATE clause for an expression in the WHERE clause of a SELECT statement. For example, when comparing 2 tables that contain a unique id that's case sensitive:
SELECT...
FROM...
WHERE sdo1.SDO_Unique_Id *= sdo2.SDO_Unique_Id COLLATE SQL_Latin1_General_CP1_CS_AS
But how do I use it when using a search_condition:
SELECT...
FROM...
WHERE SDO_Unique_Id NOT IN (SELECT SDO_Unique_Id
FROM TPEHQSQL02.TPECommon.dbo.SOD_Sales_Order_Details)
Any assistance would be greatly appreciated!!!
Thx
SELECT...
FROM...
WHERE sdo1.SDO_Unique_Id *= sdo2.SDO_Unique_Id COLLATE SQL_Latin1_General_CP1_CS_AS
But how do I use it when using a search_condition:
SELECT...
FROM...
WHERE SDO_Unique_Id NOT IN (SELECT SDO_Unique_Id
FROM TPEHQSQL02.TPECommon.dbo.SOD_Sales_Order_Details)
Any assistance would be greatly appreciated!!!
Thx