Try
Max will be the maximum length of the field your trying to convert.SELECT DISTINCT CONVERT(VARCHAR(MAX), Region) FROM Region_Mapping
Try
Max will be the maximum length of the field your trying to convert.SELECT DISTINCT CONVERT(VARCHAR(MAX), Region) FROM Region_Mapping
Last edited by Aussiebear; 04-19-2023 at 02:09 PM. Reason: Adjusted the code tags
David