<div>
aneesh how do you do this in access
</div>


<div>
All you need to do is find the index (location) of the first space and if it does exist, then do a LEFT on that length:<br />
<br />
SELECT <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LEFT(billcode, CASE WHEN CHARINDEX(' ', billcode) = 0 THEN LEN(billcode) ELSE CHARINDEX(' ', billcode) END) AS billcode<br />
FROM<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TableName
</div>


All you need to do is find the index (location) of the first space and if it does exist, then do a LEFT on that length:

SELECT
      LEFT(billcode, CASE WHEN CHARINDEX(' ', billcode) = 0 THEN LEN(billcode) ELSE CHARINDEX(' ', billcode) END) AS billcode
FROM
      TableName

<div>
how to do the same thing in access
</div>


<div>
<div class="content wysiwyg-content">
hi all i have my data like this <br />
MP1M A<br />
QX31 S<br />
MP1M A<br />
FA20 S<br />
FA20 S<br />
PTTF &nbsp; &nbsp; &nbsp;P &nbsp; &nbsp; &nbsp; &nbsp;F<br />
FN3NM0014 P &nbsp; &nbsp; &nbsp; &nbsp;S<br />
FN3NM0014 P &nbsp; &nbsp; &nbsp; &nbsp;S<br />
FN3NM0014 S &nbsp; &nbsp; &nbsp; &nbsp;S<br />
FN3NM0014 S &nbsp; &nbsp; &nbsp; &nbsp;S<br />
FN3NM0014 S &nbsp; &nbsp; &nbsp; &nbsp;S<br />
FN3NM0014 S &nbsp; &nbsp; &nbsp; &nbsp;S<br />
<br />
i want to remove all the data after the first space. i dont want anything after the first space. &nbsp;how can i write a query the filed name for this &quot;billcode&quot; &nbsp;<br />
<br />

</div>
</div>


hi all i have my data like this 
MP1M A
QX31 S
MP1M A
FA20 S
FA20 S
PTTF      P        F
FN3NM0014 P        S
FN3NM0014 P        S
FN3NM0014 S        S
FN3NM0014 S        S
FN3NM0014 S        S
FN3NM0014 S        S

i want to remove all the data after the first space. i dont want anything after the first space.  how can i write a query the filed name for this "billcode"  



sql query spaces

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.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.