Showing posts with label find length. Show all posts
Showing posts with label find length. Show all posts

My SQL get string length

My SQL get string length

Get the length of string in my sql server.In this article,I will  explain how to get the length of string in My SQL server.

My SQL string LENGTH  function Returns the length of the character string.
Syntax: LENGTH(string)


Query to get string Length in My SQL
select LENGTH('str') as str_length;

I hope above query will help you to get the length of the character string in My SQL server.


Bookmark and Share

MS SQL get string length

MS SQL get string length

Get the length of string in ms sql server.In this article,I will  explain how to get the length of string in MS SQL server.

MS SQL string LEN  function Returns the length of the character string.
Syntax: LEN(string)


Query to get string Length in MS SQL
select LEN('str') as str_length;

I hope above query will help you to get the length of the character string in MS SQL server.


Bookmark and Share