How to set field size in ms sql view?

Question

SQL

When a view is created, fields are automatically assigned a type and length. For example, the field is varchar(20), but I need it to be varchar(50).
Is it possible to manually specify the types and length of the fields?

Answer 1

CAST( [FIELDvarchar(20)] AS varchar(50))

Answer 2

Please clarify the logic. You are asking for a field in the View that is set as a string of 20 characters (no more) and you want it to become a string of 50 characters. Did I understand you correctly? if so, do you understand that this is just filling the memory with garbage? Explain your problem - I can't immediately imagine your scenario requiring such an implementation.