is there any way to cast data types?

Question

for example if i create a table of varchar and i want to turn a column into a binary

Answer 1

ALTER TABLE Table1
ALTER COLUMN Column1 <datatype>

Answer 2

Alter table xyz
Alter column yxyz binary;