SQL - Convert Text to Char

Converting a 'Text' data type to char in SQL

CAST(details AS char(6000))

Example: select id, heading, ndate, CAST(details AS char(6000)) as 'Details' from Table