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.
TEXT
VARCHAR(X)
X