|
|
Posted by Lyle Fairfield on 01/12/06 15:44
2redline wrote:
Explicit conversion from data type text to decimal is not allowed."
BOL gives the follwing defintion for text:
Variable-length non-Unicode data in the code page of the server and
with a maximum length of 231-1 (2,147,483,647) characters. When the
server code page uses double-byte characters, the storage is still
2,147,483,647 bytes. Depending on the character string, the storage
size may be less than 2,147,483,647 bytes.
I think of this as analogous in some ways to the JET Memo type.
I am guessing that:
the error message is incorrect and that actually this field is of type
varchar or similar,
or
the creator of this table made some careless error in using a text
field to hold string data that might be converted to numeric data type.
Should my guesses be right, a solution is to change the datatype of the
field (carefully!) or ... I suppose that some legerdemain might be
attempted in the T-SQL to convert the Text to VarChar to Money or
whataver .
Navigation:
[Reply to this message]
|