Hello,
If a column, data type text, with 22 characters of data, is then CAST(column_name as varchar(20)) shouldn't a warning or error be generated?
If the source is a variable defined as text instead of directly from a table, using plpsql, would that matter?
Mike