<div>
You should try the following:<br />
<br />
1. Either, widen the column, so that you can see the entire number.<br />
2. Or, convert it to a character, so you can see the entire number (if #1 does not work).<br />
<br />

<pre><code id="code-20-40853744-1">Select CONVERT(varchar(40), column12) AS column12 from mytable</code></pre>
</div>


You should try the following:

1. Either, widen the column, so that you can see the entire number.
2. Or, convert it to a character, so you can see the entire number (if #1 does not work).



Select CONVERT(varchar(40), column12) AS column12 from mytable

<div>
This should be work like this as well<br />
<br />
Select &nbsp;column12 from mytable where column12 ='-1.399726E+08'
</div>


This should be work like this as well

Select  column12 from mytable where column12 ='-1.399726E+08'

<div>
<div class="content wysiwyg-content">
This statement returns all rows:<br />
Select &nbsp;column12 from mytable &nbsp;<br />
<br />
Column12 &nbsp;datatype is &quot;real&quot;<br />
<br />
From this, I pick a random value from in the &nbsp;rows returned:<br />
for example, &nbsp; &nbsp;-1.399726E+08 &nbsp; <br />
<br />
copy an paste it into an this :<br />
Select &nbsp;column12 from mytable where column12 =-1.399726E+08<br />
<br />
This returns a null, &nbsp;no row found and returned<br />
<br />
Is the query value &nbsp;I'm seeing in the intial query, &nbsp;( -1.399726E+08 ) not exactly what's in the table?<br />
<br />
What's going in here?<br />
Thanks
</div>
</div>


This statement returns all rows:
Select  column12 from mytable  

Column12  datatype is "real"

From this, I pick a random value from in the  rows returned:
for example,    -1.399726E+08   

copy an paste it into an this :
Select  column12 from mytable where column12 =-1.399726E+08

This returns a null,  no row found and returned

Is the query value  I'm seeing in the intial query,  ( -1.399726E+08 ) not exactly what's in the table?

What's going in here?
Thanks

SQL not returning values that are in a table - datatype issue?

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.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.