Sunday, March 11, 2012

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.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|||Thanks for the reply.

No comments:

Post a Comment