Difference between varchar and varchar(max) Hello Readers, The purpose of this post is to make it clear what to use and when with respect to varchar data type in SQL Server. Varchar(max) was introduced in SQL Server 2005 version. Few years back, I wasn’t clear about the Difference between varchar and varcharmax. It was always confusing for me