Date: 10/14/05 (SQL Server)    Keywords: sql

Is there an equivalent to the SEEK command in T-SQL?

In other words, I need

SELECT left (some_column, number_of_characters_until_you_hit_the_first_space_[which_is_not_uniform]) FROM some_table

Source: http://community.livejournal.com/sqlserver/36422.html