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 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
