Solved

sql trim text

Posted on 2011-03-01
2
665 Views
Last Modified: 2012-06-27
How do I trim a text that I select from a table, so that it returns max 10 char?
For example:  "Financial Times, said it was freezing shares" should be "Financial ..."
0
Comment
Question by:johnkainn
2 Comments
 
LVL 8

Assisted Solution

by:Forefront_Data_Solutions
Forefront_Data_Solutions earned 62 total points
ID: 35007887
Select Left([FieldName],10)
From SomeTable
0
 
LVL 23

Accepted Solution

by:
Rajkumar Gs earned 63 total points
ID: 35007890
SELECT LEFT('Financial Times', 10)

Open in new window

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Database Containment - Benefits 6 35
Service Statictic 11 30
Installing SQL Server Express Management Studio 4 23
Joining Two Tables In SQL and combining records 6 51
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now