On 05/14/2014 07:29 AM, Barry Bell wrote:
> Behavior seems different if you get the text from table vs fixed value.
>
> The select 'ABCDE' from dual return a text(longchar, memo),
> The select initcap(varcharfield) from varchartable returns varchar
> The select initcap(varcharfield) from varchartable where 1=0 returns text(longchar, memo),
Where are you determining the data types?
In other words you run the SQL where and you see the output and data
type where?
>
>
>
> Barry Bell
--
Adrian Klaver
adrian.klaver@aklaver.com