Hi,

I have a column in a table which holds strings like below
What would be the best way in a select query to get the two numeric values as integers on their own so I could use them for display in seperate fields and joins on other tables?

Employee updated - Prev EmployeeNumber 4107964 - New EmployeeNumber 4107975