<div>
select * from tablename where lastname like 's%'
</div>


<div>
<div class="content wysiwyg-content">
I need a query that selects every record for which the last name (&quot;LastName&quot;) begins with &quot;S&quot;<br />
<br />
Thanks!<br />
John<br />
<br />

</div>
</div>


I need a query that selects every record for which the last name ("LastName") begins with "S"

Thanks!
John



select * from tablename where lastname like &#39;s%&#39;

In SQL Server, SELECTION based on the first letter of the entries in a given column

I need a query that selects every record for which the last name (&quot;LastName&quot;) begins with &quot;S&quot;

Thanks!
John



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.