March 6, 2017 at 3:31 am
Hi All,
SELECT Timesheet_Number, Employer_Ref, Personnel_Ref, Division, Department, Job_Location, Tax_Year, Tax_Period
FROM Timesheets
WHERE (Timesheet_Number LIKE 'EPCB%')
This returns 1000 timesheet numbers starting with 'EPCB' (Example number is 'EPCB066166')
I want to change the 'EPCB' at the start to read 'HPCB' instead. (Result number would be 'HPCB066166')
How do I do this please?
Thanks
Emma
March 6, 2017 at 3:33 am
Please don't post multiple threads for the same problem. Answered at https://www.sqlservercentral.com/Forums/1862776/Help-please-total-newbie-trying-to-learn-Trying-to-Change-the-first-character-in-a-field
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply