DATALENGTH

LEN function

String functions in MS SQL SERVER