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
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share