<div>
This code: &nbsp;select substring(advertiser_name,<wbr /> 1, charindex(' ', Advertiser_Name)) from tablename<br />
<br />
&nbsp;will give you a trailing blank.<br />
<br />
Try: &nbsp;select substring(advertiser_name,<wbr /> 1, charindex(' ', Advertiser_Name) - 1) from tablename<br />

</div>


This code:  select substring(advertiser_name, 1, charindex(' ', Advertiser_Name)) from tablename

 will give you a trailing blank.

Try:  select substring(advertiser_name, 1, charindex(' ', Advertiser_Name) - 1) from tablename


<div>
Make sure you're aware that the code you've accepted will leave you with a trailing blank in your data which means you will end up with data that you can't query and find.
</div>


Make sure you're aware that the code you've accepted will leave you with a trailing blank in your data which means you will end up with data that you can't query and find.

<div>
cmangus, give it up...He/She read it the first time...stop reaching...
</div>


cmangus, give it up...He/She read it the first time...stop reaching...

<div>
It's not reaching. &nbsp;This user will have data they can't find. &nbsp;They're expecting to find &quot;Dell&quot; and the value stored in the table is &quot;Dell &quot;&nbsp;with a trailing space. &nbsp;Those two values won't match in a query.<br />
<br />
In my last 25+ years working on data systems this has tripped me up more than once.
</div>


It's not reaching.  This user will have data they can't find.  They're expecting to find "Dell" and the value stored in the table is "Dell " with a trailing space.  Those two values won't match in a query.

In my last 25+ years working on data systems this has tripped me up more than once.

<div>
<div class="content wysiwyg-content">
I have a view with a column ADVERTISER_NAME and it hold values like<br />
<br />
Staples.com<br />
MacMall Affiliate Advantage Network<br />
Dell Home &amp;&nbsp;Home Office<br />
Buy.com USA and Buy.com CA<br />
<br />
I want to define another column that should only get the characters of column ADVERTISER_NAME &nbsp;until the first occurance of a space <br />
ie if the above value are as follows:<br />
Staples.com<br />
MacMall <br />
Dell<br />
Buy.com<br />
<br />
It is similar to the instr function in VB 
</div>
</div>


I have a view with a column ADVERTISER_NAME and it hold values like

Staples.com
MacMall Affiliate Advantage Network
Dell Home & Home Office
Buy.com USA and Buy.com CA

I want to define another column that should only get the characters of column ADVERTISER_NAME  until the first occurance of a space 
ie if the above value are as follows:
Staples.com
MacMall 
Dell
Buy.com

It is similar to the instr function in VB 

SQL View Question

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.