How do I list available casts in SQL Server?
The Microsoft Docs page for CAST and CONVERT provides a great matrix of conversions in SQL Server.

The image included in the above page:



As far as I know, there is no built-in mechanism for displaying a list of valid casts.