I need to update a column, by copying part of another column.
I plan to use a query such as:
UPDATE MAIN SET MAIN.ABBREVIATION = left(FULLDat,125);
This statement work fine when the column(FULLDat) is not a text datatype.
How can I change the above statement to be used with a text datatype column?
This query will be run from T_SQL
If, there is no way to do it this way, is there another?
Thanks in Advance.
Louiis
I plan to use a query such as:
UPDATE MAIN SET MAIN.ABBREVIATION = left(FULLDat,125);
This statement work fine when the column(FULLDat) is not a text datatype.
How can I change the above statement to be used with a text datatype column?
This query will be run from T_SQL
If, there is no way to do it this way, is there another?
Thanks in Advance.
Louiis