Home
SQL Server / T-SQL Tutorial
Query
Insert Delete Update
Table
Table Join
Data Types
Set Operations
Constraints
Subquery
Aggregate Functions
Date Functions
Math Functions
String Functions
Data Convert Functions
Analytical Functions
Sequence Indentity
View
Index
Cursor
Database
Transact SQL
Procedure Function
Trigger
Transaction
XML
System Functions
System Settings
System Tables Views
User Role
CLR
VARCHAR « Data Types « SQL Server / T-SQL Tutorial
SQL Server / T-SQL Tutorial
Data Types
VARCHAR
5.27.VARCHAR
5.27.1.
To use a string literal or a date literal in a comparison, enclose it in quotes.
5.27.2.
Varchar type value pattern matching
5.27.3.
Selecting the length of a varchar column.
5.27.4.
How to concatenate string data
5.27.5.
How to format string data using literal values
5.27.6.
How to include apostrophes in literal values
5.27.7.
VARCHAR(MAX)
5.27.8.
Replace the string '102' located at offset 9 (zero-based) with the string 'one hundred and two'
5.27.9.
City name is Dallas
5.27.10.
The IN() Function matches a field to any number of values in a list.
5.27.11.
Use REPLICATE to fill a varchar type variable
5.27.12.
CONVERT(varchar(12), OrderDate, 111)
5.27.13.
Performing String Concatenation