<div>
Thanks! I don't have the ability to add UDFs to this system, but the Upper approach worked for all characters but the &quot;~&quot;, &quot;`&quot;, &quot;@&quot;,&quot;#&quot;,&quot;$&quot;, ...<br />
Then I just filter thi smuch smaler list out. Also, I had to add a lower statement &amp;&nbsp;a casespecific statement:<br />
<br />
select * from Upper(field) &lt;&gt;&nbsp;Lower(Field) (CASESPECIFIC)<br />
<br />
Thanks again!<br />
<br />

</div>


Thanks! I don't have the ability to add UDFs to this system, but the Upper approach worked for all characters but the "~", "`", "@","#","$", ...
Then I just filter thi smuch smaler list out. Also, I had to add a lower statement & a casespecific statement:

select * from Upper(field) <> Lower(Field) (CASESPECIFIC)

Thanks again!



<div>
Cool and thanks for posting your solution, be very useful for others in the same predicament<br />
<br />
:)<br />
<br />
Best of luck with the rest of your project
</div>


Cool and thanks for posting your solution, be very useful for others in the same predicament

:)

Best of luck with the rest of your project

<div>
OK. I feel stupid, so I'll post this as well. The Between statement can still recognize numeriic ranges when dealing with characters. This is probably the best way to handle this:<br />
<br />
Select * from table where trim(field) BETWEEN '0' AND '99999'<br />
<br />
(use as many 9's as you need)<br />
<br />
<br />

</div>


OK. I feel stupid, so I'll post this as well. The Between statement can still recognize numeriic ranges when dealing with characters. This is probably the best way to handle this:

Select * from table where trim(field) BETWEEN '0' AND '99999'

(use as many 9's as you need)




<div>
<div class="content wysiwyg-content">
Does anyone know a way to filter out non-numeric characters in a char field? <br />
<br />
I am looking for something like the following that works with Teradata:<br />
Select * from table where IsNumeric(field1) = 1<br />
<br />
I have a problem converting a string to an integer on a field that &quot;should&quot; contain all numbers, but it doesn't. Or if there's any way to not get a blasted &quot;Bad Character in format or data&quot; error whenever I try to convert the field to an integer.<br />

</div>
</div>


Does anyone know a way to filter out non-numeric characters in a char field? 

I am looking for something like the following that works with Teradata:
Select * from table where IsNumeric(field1) = 1

I have a problem converting a string to an integer on a field that "should" contain all numbers, but it doesn't. Or if there's any way to not get a blasted "Bad Character in format or data" error whenever I try to convert the field to an integer.


Teradata IsNumeric

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.