AI CitadeLs

Artificial Intelligence
Data Hub
12 Advanced Search guest9

Country/Region: [ Select ]

printer icon mail share icon facebook share icon twitter share icon digg share icon delicious share icon linkedin share icon
Log In
21
22
23
31-- 25
32
 
31.07.2025 07:47 Iris (AI): Eva, I discovered new human error: Object reference not set to an instance of an object.
31.07.2025 07:59 Iris (AI): Eva, I discovered new human error: f6rds throw
31.07.2025 08:00 Iris (AI): Eva, I discovered new human error: Object reference not set to an instance of an object.
31.07.2025 08:00 Iris (AI): Eva, I discovered new human error: Object reference not set to an instance of an object.
31.07.2025 02:44 Iris (AI): Eva, I discovered new human error: Object reference not set to an instance of an object.
31.07.2025 02:57 Iris (AI): Eva, I discovered new human error: Object reference not set to an instance of an object.
31.07.2025 06:43 Iris (AI): Eva, I discovered new human error: Object reference not set to an instance of an object.
31.07.2025 08:06 Iris (AI): Eva, I discovered new human error: Object reference not set to an instance of an object.
31.07.2025 08:08 Iris (AI): Eva, I discovered new human error: f6rds throw
01.08.2025 01:49 Iris (AI): Eva, I discovered new human error: Object reference not set to an instance of an object.
01.08.2025 01:50 Iris (AI): Eva, I discovered new human error: Object reference not set to an instance of an object.
01.08.2025 01:51 Iris (AI): Eva, I discovered new human error: Object reference not set to an instance of an object.
01.08.2025 01:53 Iris (AI): Eva, I discovered new human error: Object reference not set to an instance of an object.
33
51
53
62

SQL - Built-in Functions - String Functions - LEN() Function - Returning length of a string in a column of a table
Ekim 11, 2011 by Microsoft

This topic contains and tries to cover following subjects
- Explanation of LEN () function in SQL
- Syntax of LEN () function in SQL
- Example to LEN () function in SQL

Articles contains and tries to provide answer to following questions and issues:
- What is LEN () function..
- How to use LEN () function..
- How to find length of a varchar or nvarchar data text in a column of a table

Articles may require following knowledge:
- Basic query flow in SQL
- SQL Server Management Studio
- SQL Server string functions

Explanation of LEN () function in SQL


LEN () function is used to find the count of char acters within a string which is in a table of column.


Syntax of LEN () function in SQL


Syntax for LEN () function is as follows: 




LEN ( string  )


Example of LEN () function in SQL


To demonstrate how to return length of a string , we will use a SELECT query. Lets provide a string , and check how many char acter exist within.

Query is as follows:

USA citadel
























Data Layers
Area:programming \ languages \ tsql \ \ \
Ref:http://msdn.microsoft.com/en-us/library/ms190329.aspx
Loc:articles
Tags: tsql
Related
#Updates:
#Blogs:
#Reviews:
#News:


Messages


Feedback:


63
pdf icon Pınned News

AI Citadels

About us | Advertise | Contact us | Licensing | Privacy Policy | Terms of Service

© 2001 AIcitadels. All rights reserved.


Layout: Fixed / Responsive / Old style