Concatenate in sql teradata

I have the following code

Sel account,Div,Modl,Sub_modlFrom table_1

Where Div gives me 01, Modl = 1 is CS, and Sub_modl=1.I should combine these fields to have:

01_CS_0101

Where the first 01 comes from Div, CS comes from Modl, and the last 1 in 0101 comes from Sub_modl. How could I get this result using concat function in teradata?

1

Best Answer

You can use concat

select account,concat(Div, '_', Modl, '_', '010', Sub_modl) as colNamefrom table_1

or you can use ||

select account,(Div || '_' || Modl || '_' || '010' || Sub_modl) as colNamefrom table_1

Random Posts

How to calculate Read Capacity Unit and Write Capacity Unit for DynamoDBWhat are the files that the .dockerignore works on?UNION ALL / UNION on PrestoFile type associated icons package for flutter?How to create unique keys for React elements?Google Apps Script - IF ELSE with multiple conditions combined with AND and ORconda init doesn't initialize shell?What is SSL security policy for ELBZip Three Different Mono of Different Typeuse nth-child(odd) css selector with Tailwind on the parent elementNotepadd++ plugin sqlinform for SQL formatting bright orange color backgroundHow do you or a vector with a single bit in verilog?Root and normal user can't find commandsGolang Round to Nearest 0.05Select method in List<t> CollectionCombining TF-IDF with pre-trained Word embeddingsHow do I use GridLayout and multiple Panels?How to validate java plain methods using javax validationCan we read queue data created by bullmq in nodejs with pythonVariable might not have been initialized error