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','')




    Zoho Marketing Automation

              Zoho Pagesense Resources

                Zoho SalesIQ Resources



                      Zoho TeamInbox Resources

                        Zoho DataPrep Resources



                          Zoho CRM Plus Resources

                            Zoho Books Resources


                              Zoho Subscriptions Resources

                                Zoho Desk Resources

                                  Zoho Projects Resources


                                    Zoho Sprints Resources


                                      Qntrl Resources


                                        Zoho Creator Resources


                                          Zoho WorkDrive Resources




                                              Zoho Campaigns Resources

                                                Zoho CRM Resources

                                                        Design. Discuss. Deliver.

                                                        Create visually engaging stories with Zoho Show.

                                                        Get Started Now