I am copying TEXT columns to another table where the destination column is VARCHAR(MAX).

It appears that this is an implicit conversion and that I do not need to write an explicit CAST for it.

Is this correct?


As detailed in the excellent Microsoft Documentation, conversions from text to varchar can indeed be implicit.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.