how to change data type in select query code example

Example: sql alter column size

ALTER TABLE table_name
ALTER COLUMN column_name datatype;