Substring method's in SQL query

Question

This is the query which i am using to reduce the length of the character.

these are some example char("For more information about the valid SQL Server 2005 data types that can be ... Is an integer that specifies where the substring starts. start can be of type bigint.")

if i give substring to fix the length up to 15 . the rest of the char should show like this way(...)

my sql query is this.....

select substring('For more information about the valid SQL Server 2005 data types that can be ... Is an integer that specifies where the substring starts. start can be of type bigint.',0,15) from Admin

for example: it should show like this

For more information about the valid SQL Server 2005 data.

"The rest should show like ....", is this true or do you want to shorten the string? What does not work? — Tim Schmelter
– Tim Schmelter, Commented Nov 7, 2012 at 9:08

Pranav · Accepted Answer · 2012-11-07 09:10:42Z

2

select substring('For more information about the valid SQL Server 2005 data types that can be ... Is an integer that specifies where the substring starts. start can be of type bigint.',0,58)+'.........'

answered Nov 7, 2012 at 9:10

Pranav

8,9214 gold badges28 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TechDo · Accepted Answer · 2012-11-07 09:07:54Z

0

Did you mean this:

select Left('For more information about the valid SQL Server 2005 data', 15)+'...'

Specify the number of characters to be shown as the second parameter of system defined function LEFT.

answered Nov 7, 2012 at 9:07

TechDo

18.7k3 gold badges55 silver badges64 bronze badges

Comments

vkamayiannis · Accepted Answer · 2012-11-07 09:11:05Z

0

you can use something like this:

    select substring('For more information about the valid SQL Server 2005 data types that can be ... Is an integer that specifies where the substring starts. start can be of type bigint.',0,15)+replicate('.', 25) 
from Admin

answered Nov 7, 2012 at 9:11

vkamayiannis

7353 silver badges13 bronze badges

Comments

Ahmad · Accepted Answer · 2012-11-07 09:12:09Z

0

If you want the output to be something like this

First_15_letters_ ... _Last_15_letters

Then here is one way to do it

select 
substring('For more information about the valid SQL Server 2005 data types that can be ... Is an integer that specifies where the substring starts. start can be of type bigint.',0,15) 

+ '...' + 

right('For more information about the valid SQL Server 2005 data types that can be ... Is an integer that specifies where the substring starts. start can be of type bigint.',15)

from Admin;

answered Nov 7, 2012 at 9:12

Ahmad

12.8k7 gold badges53 silver badges98 bronze badges

Comments

Vikram Jain · Accepted Answer · 2012-11-07 09:13:35Z

0

Please, not down from here :
=======================================================
  select substring('For more information about the valid SQL Server 2005 data types that
    can    be ... Is an integer that specifies where the substring starts. start can 
    be of type bigint.',0,15) 
--Not need "from Admin"
===============================================================
select substring(colname,0,15) from Admin
--"from Admin" Need when columnname is required

answered Nov 7, 2012 at 9:13

Vikram Jain

5,6081 gold badge22 silver badges31 bronze badges

Collectives™ on Stack Overflow

Substring method's in SQL query

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related