KACE Reports - adding text before every result in a column
I would like to add TICK:ID to the results in the Ticket ID column. So, instead of getting 1234 as the ticket number I would get TICK:ID 1234
I'm sure this is super easy but I have no SQL skills and this forum has been so helpful. Thanks in advance.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
9 years ago
The MySQL function for this is concat:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat
In this case you need to use the following in the select statement:
concat("TICK:ID ", HD_TICKET.ID)
Comments:
-
Thank you so much for your quick reply. It worked perfectly! - twaechter 9 years ago
