Implicit conversion between data types

This is what you need to remember about implicit conversion:

For comparing two values in SQL Server, they need to have the same data type.
If the data types are different, SQL Server implicitly converts one type to another, based on data type precedence.
The data type with the lower precedence is converted to the data type with the higher precedence.

In this exercise, you are going to test if explicit conversion works between a numeric type and a character. use information from the conversion table, where the implicit and explicit conversions between all data types are presented. You are going to try an implicit conversion between two different data types.

For this, you will use the voters table and will compare the total_votes numeric column with a character.

This exercise is part of the course

Functions for Manipulating Data in SQL Server

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT 
	first_name,
	last_name,     
	total_votes
FROM voters
___

Edit and Run Code