<div>
select decode(mod(STREET_NUMBER_F<wbr />ROM,2),1,'<wbr />ODD',0,'EV<wbr />EN','ERROR<wbr />') from street_numbers<br />
<br />

</div>


select decode(mod(STREET_NUMBER_FROM,2),1,'ODD',0,'EVEN','ERROR') from street_numbers



<div>
Hi<br />
<br />
I made a mistake, there are characters in these fields, so I have to deal with values like 1A, 2B, 123C, etc. So I'll also need a method to filter out the characters before determining odd/even.<br />
<br />
Take care,<br />
Shayne
</div>


Hi

I made a mistake, there are characters in these fields, so I have to deal with values like 1A, 2B, 123C, etc. So I'll also need a method to filter out the characters before determining odd/even.

Take care,
Shayne

<div>
sorry,<br />
<br />
if they are text use this<br />
<br />
select decode(mod(to_number(STREE<wbr />T_NUMBER_F<wbr />ROM),2),1,<wbr />'ODD',0,'E<wbr />VEN','ERRO<wbr />R') from street_numbers<br />
<br />
but that will only work if the data is numeric, so 123A will cause error ORA-01722: invalid number<br />
<br />

</div>


sorry,

if they are text use this

select decode(mod(to_number(STREET_NUMBER_FROM),2),1,'ODD',0,'EVEN','ERROR') from street_numbers

but that will only work if the data is numeric, so 123A will cause error ORA-01722: invalid number



<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have two text fields in a table called STREET_NUMBER_FROM and STREET_NUMBER_TO that only have numerical characters, what is the fastest SQL method for determining if one or both of the fields represents an even or odd number?<br />
<br />
Thanks and take care,<br />
Shayne
</div>
</div>


Hi

I have two text fields in a table called STREET_NUMBER_FROM and STREET_NUMBER_TO that only have numerical characters, what is the fastest SQL method for determining if one or both of the fields represents an even or odd number?

Thanks and take care,
Shayne

Best way to determine even/odd using SQL

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.