<div>
Use LEFT function:<br />

<pre><code id="code-20-40586232-1">Select * From MARA_MBEW Where LEFT([Total Stock],1) ='2'</code></pre>
</div>


Use LEFT function:


Select * From MARA_MBEW Where LEFT([Total Stock],1) ='2'

<div>
Lokesh is correct, the best style for performance is:<br />
<br />
Where [Total Stock] Like '2%'
</div>


Lokesh is correct, the best style for performance is:

Where [Total Stock] Like '2%'

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I am trying to list all records where the number starts with a 2 but I get the error<br />
<br />
Argument data type decimal is invalid for argument 1 of substring function.<br />
<br />
I know that the following syntax doesn't work. What would the correct syntax be?<br />
<br />
Select * From MARA_MBEW Where SubString([Total Stock],1, 1) = 2
</div>
</div>


Hi

I am trying to list all records where the number starts with a 2 but I get the error

Argument data type decimal is invalid for argument 1 of substring function.

I know that the following syntax doesn't work. What would the correct syntax be?

Select * From MARA_MBEW Where SubString([Total Stock],1, 1) = 2

SQL Argument data type decimal is invalid for argument 1 of substring function.

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.