Not sure how to get this correct?
Thank you.
ALTER TABLE "X" ALTER COLUMN "Date" SET DEFAULT CURRENT_DATE
SELECT "Date",
right('0'|| Month("Date"),2) || right('0' || Day("Date"),2) || right('0' || Year("Date"),2)|| right('0' || cast(rand()*30 AS TINYINT) +1, 2) || 'wo' AS "Concatenation"
FROM "TBL"
SELECT TO_CHAR("Date",'MMDDYY')|| LPAD(CAST(RAND()*30 AS TINYINT)+1,2,'0') || 'wo' AS "Concatenate"
FROM "TableX"
Users browsing this forum: No registered users and 0 guests