/bundles/itninjaweb/img/Breadcrumb_cap_w.png

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   [ - ] Hide Comments

Comments

Please log in to comment

Answer this question or Comment on this question for clarity

Answers

1
Use concatenation...

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

Please log in to comment