How to convert a column of type TEXT to VARCHAR?

Question

Is there a way to convert a column with data in it as TEXT to VARCHAR(X) easily? There are no existing records in the column is longer than X.

Answer 1

Yes for sure

ALTER TABLE table_name MODIFY column_name VARCHAR(X)

Answer 2

For MS SQL:

ALTER TABLE table_name ALTER COLUMN column_name datatype(value) 

For MySQL

ALTER TABLE table_name MODIFY column_name datatype(value)