title: Remove all after space in SQL Server data column
body: <p>I have a data column in SQL Server that always starts with a number and sometimes has a space after the number with additional details. This is a text column. I need a query that will remove everything after and including space if there is a space or additional info. In other words, I need only the number to be in this column. Sometimes there is only a number and sometimes not. Can I get assistance in a query that will do this?</p>