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 perf

Re: Case Sensitive SQL JOIN

Yes. convert(varbinary, 'a') = convert(varbinary, 'A') - Original Message - From: Duane Boudreau <[EMAIL PROTECTED]> Date: Friday, January 10, 2003 1:10 pm Subject: Case Sensitive SQL JOIN > Hi All, > > Using SQLServer2k, is there a way to do a cas

Re: Case Sensitive SQL JOIN

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 SQLServer