nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

concatenate 2 string columns in data set query

gourav

select comp_nm, (complc_addr1+" "+complc_city) as address from comp the query outputs the numeric value instead of joining two strings.

Find more posts tagged with

Comments

micajblock

What database? '+' is not the concatenation symbol in SQL. Usually it is '||'. Google the syntax for your specific database.

gourav

I changed + to || but no got the required output I am using mysql database

micajblock

So you did not Google like I suggested. I did. For MySQL you need to use a function. <a data-ipb='nomediaparse' href='http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat'>http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat</a>

gourav

thank u.