views:

22

answers:

1

For my existing data, both RoleName and LoweredRoleName are same, but some are lower case and some are in same case too.

Anyone knows what is the use of column LoweredRoleName in aspnet_users table?

A: 

They are the same. I think used internally by .net. Maybe LoweredRoleName is used to avoid using SQL's LOWER() function.

Jeroen