How to concatenate strings with padding in sqlite

I have three columns in an sqlite table:

    Column1    Column2    Column3
    A          1          1
    A          1          2
    A          12         2
    C          13         2
    B          11         2

I need to select Column1-Column2-Column3 (e.g. A-01-0001). I want to pad each column with a -

I am a beginner with regards to SQLite, any help would be appreciated

3 Answers
3

Leave a Comment