title: TSQL - Locating first occurrence of value in a string
body: <p>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:<br /> <code>**Left([Names],InStr(1,[Names]," ")-1)</code>, but can't find out how to do it in SQL 2005. All help will be appreciated.</p>