Post reply

Returning two characters from a column

  • November 13, 2015 at 4:49 am

    #322507

    Hi

    I have a column that has values [1,2,3....10,11,13,14 ...]

    I want to return just two characters, e.g [01, 02, 03....10,11,12...]

    I concatenated a string before to

    '0'||CAST(m.d_depend as varchar(2)) as 'depend'

    but then I would get three character e.g [010,011,012...]

    How do I solve this

  • November 13, 2015 at 4:53 am

    #1839581

    Use the RIGHT() function.

    Right('0' + col,2)

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • November 13, 2015 at 9:28 am

    #1839642

    hoseam (11/13/2015)

    Hi

    I have a column that has values [1,2,3....10,11,13,14 ...]

    I want to return just two characters, e.g [01, 02, 03....10,11,12...]

    I concatenated a string before to

    '0'||CAST(m.d_depend as varchar(2)) as 'depend'

    but then I would get three character e.g [010,011,012...]

    How do I solve this

    That syntax seems like a combination from Oracle and SQL server.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • November 13, 2015 at 1:10 pm

    #1839720

    Luis Cazares (11/13/2015)

    hoseam (11/13/2015)

    Hi

    I have a column that has values [1,2,3....10,11,13,14 ...]

    I want to return just two characters, e.g [01, 02, 03....10,11,12...]

    I concatenated a string before to

    '0'||CAST(m.d_depend as varchar(2)) as 'depend'

    but then I would get three character e.g [010,011,012...]

    How do I solve this

    That syntax seems like a combination from Oracle and SQL server.

    That is definitely Oracle syntax. The || is the concatenation operator in Oracle.

    Regarding the problem, what happens if your numbers get up to 3 digits in length? What if you have [1,2,,,5,6] as one of your strings?

    For a great string splitter function, see the link in my signature. I don't know if it'll work in Oracle because I've never tried.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • November 13, 2015 at 1:18 pm

    #1839725

    Ed Wagner (11/13/2015)

    Luis Cazares (11/13/2015)

    hoseam (11/13/2015)

    Hi

    I have a column that has values [1,2,3....10,11,13,14 ...]

    I want to return just two characters, e.g [01, 02, 03....10,11,12...]

    I concatenated a string before to

    '0'||CAST(m.d_depend as varchar(2)) as 'depend'

    but then I would get three character e.g [010,011,012...]

    How do I solve this

    That syntax seems like a combination from Oracle and SQL server.

    That is definitely Oracle syntax. The || is the concatenation operator in Oracle.

    But Oracle uses varchar2 instead of varchar and TO_CHAR() instead of CAST().

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 5 posts - 1 through 4 (of 4 total)

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