How to Convert Datatypes in Azure SQL Using TSQL Cast & Convert

In this episode, we're going to take a look at the Cast and Convert functions in T-SQL for Azure SQL and SQL Server. Both Cast and Convert are handy for changing the data in certain fields of a query to another datatype. Sometimes we end up in situations where numbers or dates were stored in text fields, but we actually want the real datatype to be used in our query outputs, views, and stored procedures. Cast and Convert are two ways to get the output datatypes that we want.

Interested in transforming your career or finding your next gig?

Want my team to do a project for you? Let's get to it!

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Demo of my BZ RDP Cloaker:

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

#azuresql #dataengineering #sqlserver