I have a basic SQL select query and one of the Column names is "docid" which is a decimal number field. I would like to be able to convert this decimal number for each record into hexadecimal by incorporating within the query & inserting the hexadecimal value for each record into a new column each time the query is run.
Is this possible?
select d.docid, d.name, r.date, u.Username
FROM docs d
join rev r on d.DocID = r.DocID
join users u on r.userid = u.userid