Hi,
I'm trying to alter some data in a column, most of the data contains just 4 characters, such as '1234', but the odd row contains '5678-09'. The only consistent character is the '-' but I want to update all rows to only contain the first 4 numerical characters.

What would be the best way to achieve this within t-SQL?

Any help will be greatly appreciated.

Mosser212