TSQL - Locating first occurrence of value in a string
I need to run a simple select statement for a column called AddrZip to show all records that contain  '1/2 ' after the first space in the column. In Access 2007 it would be **Left([Names],InStr(1,[Names]," ")-1), but can't find out how to do it in SQL 2005. All help will be appreciated.
TSQL - Locating first occurrence of value in a string
===

I need to run a simple select statement for a column called AddrZip to show all records that contain  '1/2 ' after the first space in the column. In Access 2007 it would be **Left([Names],InStr(1,[Names]," ")-1), but can't find out how to do it in SQL 2005. All help will be appreciated.