Remove specific Text from a String

Remove specific Text from a String

I want to remove specific text from all Job Numbers in a specific column.

In my specific case, I want to REMOVE the letter T from the "JobNumber" column

I get an error when I use the code below. Any suggestions what I am doing wrong, how to fix this? Also the error I get is in an image below

SELECT
"Division",
        "DepartmentName",
        "CustomerName",
        "JobNumber",
        "PM",
        "LB",
        "ES",
        "EstimatedHours",
        "ActualHours",
        "PercentComplete",
        "PM Percent Complete",
        "EstStartDate",
        "EstEndDate",
        "ActStartDate",
        "ActEndDate",
        "Dock Date",
        "Due Date",
        "Kickoff Date"
        "Job Award Date",
        "JobStatus",
        "Budget Consumed",
        "Budget Consumed Percent_Reference Only"
FROM "Eagle_AllHoursReport"
REPLACE ("JobNumber",'T','')