There's several ways to do this. A decent starting point is here: http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm
Basically, the options are: play with collation order and collation functions/clauses (or change the collation of the database) use binary comparisons which *are* case sensitive I think the second is probably easier. Something like SELECT * FROM a INNER JOIN b ON (CAST(a.id as binary(255))=CAST(b.id as binary(255))) or maybe with a checksum which *may* be faster FROM a INNER JOIN b ON (BINARY_CHECKSUM(a.id)=BINARY_CHECKSUM(b.id)) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ----- Original Message ----- From: "Duane Boudreau" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 10, 2003 3:10 PM Subject: Case Sensitive SQL JOIN > Hi All, > > Using SQLServer2k, is there a way to do a case sensitive join? *my > SQLServer2k server is setup not to be case sensitive. > > The reason I ask is because I am pulling data from an external data feed > that has a unique identifier that is case sensitive. > > Its a very large query and I need to perform this function in the SQL? > > Duane > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
