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.

Answer Summary:
0 Comments   [ + ] Show Comments


Please log in to comment


The MySQL function for this is concat:

In this case you need to use the following in the select statement:
concat("TICK:ID ", HD_TICKET.ID)

Answered 02/19/2015 by: chucksteel
Red Belt

  • Thank you so much for your quick reply. It worked perfectly!
Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja