how big can a varchar be in sql code example

Example: varchar max length

65,535

The length can be specified as a value from 0 to 65,535. 
The effective maximum length of a VARCHAR is subject to 
the maximum row size (65,535 bytes, which is shared among all columns) 
and the character set used.