SQL select query 1

[RosieGp]

Ok in my Employee_YearsOfWork table... I have the following:
Employees_YearsOfWork
ID Years Date_Completed
1-1 2 Dec - 12
12-2 7 June - 15
12-5 15 Aug - 11
I have to just display Date_Completed as following:
Employees_YearsOfWork
ID Years Date_Completed
1-1 2 12
12-2 7 15
12-5 15 11

How do I trim everything before the 12 or 15 or 11...
My query:

Select ID, Years, Date_Completed
From Employees_YearsOfWork

Thanks in advance for your help...

 

[markros]

Assuming the number part always comes after - and a space, try

select Date_Completed, substring(Date_Completed,charindex('- ',Date_Completed) + 2, len(Date_Completed)) as NumberOnlyPart
froom Employees_YearsOfWork

PluralSight Learning Library