Re: Dumb Character Column
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 27 Jan 2010 08:11:59 +0100
Message-ID: <4b5fe73c$0$22942$e4fe514c_at_news.xs4all.nl>
Op 26-1-2010 23:50, The Magnet schreef:
>
> Hi,
>
> Ok, whomever wrote this dumbass application should be put on trial.
>
> Anyhow, we have a column in our table which is defined as VARCHAR2,
> but contains both numbers AND character data.
>
> Problem is that we need to do some< & > in a query on the numeric
> content. But, because of the character data we get an invalid
> number. If we quote the numbers it does a character compare, not a
> numeric compare.
>
> Still looking on the internet for an answer, but anyone here have any
> ideas?
>
> Thanks!
Date: Wed, 27 Jan 2010 08:11:59 +0100
Message-ID: <4b5fe73c$0$22942$e4fe514c_at_news.xs4all.nl>
Op 26-1-2010 23:50, The Magnet schreef:
>
> Hi,
>
> Ok, whomever wrote this dumbass application should be put on trial.
>
> Anyhow, we have a column in our table which is defined as VARCHAR2,
> but contains both numbers AND character data.
>
> Problem is that we need to do some< & > in a query on the numeric
> content. But, because of the character data we get an invalid
> number. If we quote the numbers it does a character compare, not a
> numeric compare.
>
> Still looking on the internet for an answer, but anyone here have any
> ideas?
>
> Thanks!
What version of Oracle (Database)?
Shakespeare Received on Wed Jan 27 2010 - 01:11:59 CST