Cast and Convert
CAST and convert function converts a value (of any type) into a specified datatype.
------------------------------------------------------------------------------------------------------
select * from company
select cast(id as char)+first_name from company
select convert(char,id)+first_name from company
select convert(varchar,joining_date,103) from company where id=2
select cast('sdfsdf' as int)
select try_cast('dfsdf' as int)
select convert(int,'dfsdf')
select try_convert(int,'dfsdf')
