Post reply

REPLACE AND UPPER CASE

  • June 23, 2014 at 12:06 pm

    #308478

    Given the phrase "A,b,B,a,c,b" is there a way to use my REPLACE keyword a return the string:

    103!3@107@2!5#3@

    instead of: 2!3@3@2!5#3@ ?

    SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    Place, 'a','2!'), 'b','3@'), 'c','5#'),

    'A','103!'), 'B','107@'), 'C','109#')

    FROM names

  • June 23, 2014 at 12:28 pm

    #1724155

    SQLalchemy (6/23/2014)

    Given the phrase "A,b,B,a,c,b" is there a way to use my REPLACE keyword a return the string:

    103!3@107@2!5#3@

    instead of: 2!3@3@2!5#3@ ?

    SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    Place, 'a','2!'), 'b','3@'), 'c','5#'),

    'A','103!'), 'B','107@'), 'C','109#')

    FROM names

    Collation would do this.

    Find the difference in these two columns.

    SELECT [TextNoCoolation] = replace(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    'A,b,B,a,c,b' , 'a','2!'), 'b','3@'), 'c','5#'), 'A','103!'), 'B','107@'), 'C','109#'),',','')

    ,

    [TextwithCoolation] = replace(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

    'A,b,B,a,c,b' COLLATE SQL_Latin1_General_CP1_CS_AS, 'a','2!'), 'b','3@'), 'c','5#'), 'A','103!'), 'B','107@'), 'C','109#'),',','')

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply