CODEWITHSUNDEEP
sql
Nidhin_toms
Nidhin_toms

Reputation: 737

How to display literal strings in SQL query results?

This might be a simple problem. i would like to add special characters to my concatenated column when i display it. This the query that I have:-

select emp"EMP",concat(INITCAP(lastname), 
       INITCAP (firstname))”Full name”,
       INITCAP (goals)”Goals” from employeesTHREE ORDER BY lastname;

result needed:-

EMP     Fullname                       Goals
___________________________________________

1       thomas,mathew ~~~~~~~~~~~~~~~~ To be the best

Upvotes: 1

Views: 2992

Answers (1)

Derek
Derek

Reputation: 23228

You should be able to just do something like this...

concat(concat(INITCAP(lastname), INITCAP (firstname)), '~~~~~')

Upvotes: 1

Related Questions