var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Find if there is a character in a field
I am trying to see if there is a non-numeric value in a varchar2 field - am not very good and tried translate function to no avail.
Would anyone have an easy way to get the rows.
You could use TRANSLATE to remove all the digits, and see if anything remains:
WHERE TRANSLATE ( col, 'x0123456789', 'x' ) IS NULL
If you need to know that the column contains a valid number (e.g. 1.234 but not 18.104.22.168) then you would need a function like:
Then you can use it in SQL like this:
create or replace function is_number(x in varchar2) return integer
n := to_number(x);
when others then
WHERE is_number(col) = 1
Actually just got it there, it's not perfect but it got me the rows in question:
where rtrim(ltrim(TRANSLATE(CALL_START_TIME,'1234567890' ,' '))) is not null;