Alexander Gräf wrote:

>I guess you could find it out by first trying to cast the old value to the new, e.g.:
>
>SELECT CAST(TheColumn AS VARCHAR(400)) FROM TheTable;
>
>Or in your example:
>
>SELECT CAST(TheColumn AS BLOB SUB_TYPE 1 SEGMENT SIZE 100) FROM TheTable;
>
>Which will not work, as far as I know. Only way to persist your data would be to add a second column with the blob type, and copy the data with an UDF, and drop the old column afterwards.
>
>Cheers
>
>

I think conversion from/to blob sub type text to/from varchar will be
handled automatically by the engine.

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 18/03/2005