0

i need a querry to add -- in the end of a table. for example if i have a table like

tb name ze

   ad|ID|   aa  |
    --------------
    01|02|aa01   |
    02|03|aa02   |

how do i add -- to the end of all fields of aa column to be like aa01--\aa02--?

2
Contributors
5
Replies
6
Views
5 Years
Discussion Span
Last Post by Stardemos
0

thanks, i'll try it, if i cannot do it wright, i'll ask for help again

0

or i did not understand the concat function or it just dont do what i need

as far as i understod, concat function output the table contens plus the separator,
what i need is to add in the table content the "--" in the end of all the column.

0

thanks, i've found a way earlier, just fotgot to post it... after driking another coffe i finaly understand it.

THANKS

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.