MSSQL – How to separate first and last name Vis Dotnet 2 years ago Simple example that shows how to read until first empty space and after first empty space More info http://howtodomssqlcsharpexcelaccess.blogspot.ca/2015/06/mssql-how-to-get-first-name-and-last.html