Example on SQLSERVER substring function

Hi,
Check this link
http://www.sql-server-helper.com/tips/split-name.aspx

Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Self-innovator, if this helps please login to Mark As Answer. | Alert Moderator

select LEFT('sanjay',5)

select SUBSTRING('sanjay',1,5)

try this

Thanks,
Sanjay

Self-innovator, if this helps please login to Mark As Answer. | Alert Moderator

Try this...

http://msdn.microsoft.com/en-us/library/ms187748.aspx

http://www.dotnetfunda.com/articles/article476-sql-server-substring-explained.aspx

For more reference... search with google...

Thanks,
T.Saravanan

Self-innovator, if this helps please login to Mark As Answer. | Alert Moderator

Hi

SUBSTRING : Returns part of a given string.

SUBSTRING function retrieves a portion of the given string starting at the specified character(startindex) to the number of characters specified(length).

Syntax: SUBSTRING (string,startindex,length)
SELECT SUBSTRING('STRING FUNCTION', 1, 6) Result : STRING
SELECT SUBSTRING('STRING FUNCTION', 8, 8) Result : FUNCTION

If this helps you .
Please "Mark as Answer"

Self-innovator, if this helps please login to Mark As Answer. | Alert Moderator

CREATE TABLE CTEST(CID INT IDENTITY(1,1),CLSNAME VARCHAR(90))





INSERT INTO CTEST VALUES('TESSTUSER')



SELECT * FROM CTEST



SELECT SUBSTRING(CLSNAME,1,4) FROM CTEST

REGARDS

sriram

Self-innovator, if this helps please login to Mark As Answer. | Alert Moderator

SUBSTRING


Substring returns the part of the string from a given characterexpression. The general syntax of Substring is as follows :

SUBSTRING(expression, start, length)

Here the function gets the string from start to length. Let us take an example below:

Collapse | Copy Code
SELECT OUT = SUBSTRING('abcdefgh', 2, 3)
The output will be "bcd".

Self-innovator, if this helps please login to Mark As Answer. | Alert Moderator

Please refer this links
http://msdn.microsoft.com/en-us/library/ms187748.aspx
http://www.codeproject.com/Articles/38998/Most-Commonly-Used-Functions-in-SQL-Server-2005-20

Self-innovator, if this helps please login to Mark As Answer. | Alert Moderator