Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Posts
    2

    Smile Unanswered: Change collation in SS7

    How can I make just one particular column on a table in SS7 be case-sensitive? I know it can be done in SQL 2000.

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Afraid you can't. This is a new feature in v2000.

    You can code in case sensitivity by

    where fld = @fld
    and convert(varbinary,fld) = convert(varbinary,@fld)

    the 'where fld = @fld' is just so it can use any indexes

  3. #3
    Join Date
    Jan 2002
    Posts
    2
    Thanks for the reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •