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

Comments

Please log in to comment

Answers

1
Use concatenation...

CONCAT('TICK:ID', HD_TICKET.ID)
Answered 02/19/2015 by: h2opolo25
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity