updating a text column

[lisa]

how can i update a column with datatype of text with a combination of columns having a datatype of float? do i convert the float columns to varchar/char/?? and/or can i convert the column i am updating?

thanks!

[Thomas R. Hummel]

You cannot convert the column that you are updating (I'm not sure what you were getting at with that...), but you can convert the source columns (or variables) with either the CONVERT or CAST functions. Check your online help for the specifics of these functions, but it would basically be something like:

update MyTable
set MyString = convert(varchar(20), @MyInteger)
where ...

or

update MyTable
set MyString = cast(@MyInteger as varchar)
where ...

You can include the length in the cast statement as well if you prefer.


------------
lisa at 9/20/01 3:11:33 PM


how can i update a column with datatype of text with a combination of columns having a datatype of float? do i convert the float columns to varchar/char/?? and/or can i convert the column i am updating?

thanks!

[Bob]

Can't convert float to text or text to float. Try converting the float data to char/varchar, then to text?


------------
lisa at 9/20/01 3:11:33 PM


how can i update a column with datatype of text with a combination of columns having a datatype of float? do i convert the float columns to varchar/char/?? and/or can i convert the column i am updating?

thanks!