Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Need to convert lowercase characters to 'a' and uppercase to 'A' RE: Need to convert lowercase characters to 'a' and uppercase to 'A'

  • January 20, 2018 at 7:27 am

    #1976624

    Jeff Moden - Friday, January 19, 2018 9:59 AM

    srikanthrv - Friday, January 19, 2018 6:24 AM

    Hi,
    I have a requirement to anonymise the data in table by replacing all the lowercase characters to 'a' and uppercase to 'A'. I am not sure if this can be achieved given the sql server case insensitivity?
    Any thoughts on this?

    I do hope that you're actually kidding or that this is just a simple example of what the larger and more complex task will be because changing lower case to upper is NOT a form of anonymising anything.   I'll also state that simple character replacement isn't a valid form of anonymising anything either because there's software out there that can figure out your magic decoder ring in seconds.

    +100

    ...