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:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1
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)

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