Q: loweredrolename in aspnet_users table (SQL Server 2005) 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.

A: I'm sure there is a reason for it, on the cusp it seems redundant and a design smell. 
