Return first 100 letters from database field?

Question

In my database MYDB i have a table called MYTABLE and inside it I have a column called NAME. I want to only return the first 100 characters of the column NAME. (NAME can be up to 2000 characters).

How can this be done in SQL as I want to set the first 100 characters to a ASP.NET label.

Thanks in advanced!

Answer 1

select left(NAME, 100) as Name, ... from MYTABLE...

Answer 2

You can use the LEFT function, e.g.

SELECT LEFT(mt.NAME, 100) AS SHORTNAME FROM MYTABLE mt

Answer 3

Use Substring:

SELECT SUBSTRING(NAME, 1, 100) AS [ShortName] 
FROM MYTABLE

Answer 4

Hi,

SELECT SUBSTRING( NAME, 0 , 100 )
FROM MYTABLE 

Answer 5

Use SUBSTRING function:

SELECT SUBSTRING(NAME, 1, 100) AS LABEL FROM MYTABLE

Answer 6

Use the LEFT function:

SELECT LEFT(NAME, 100) AS NAME FROM MYTABLE

Answer 7

See following
http://msdn.microsoft.com/en-us/library/aa226054%28SQL.80%29.aspx

Answer 8

I like it with dots to show that there is more text

SELECT
  CASE
    WHEN LEN(NAME) <= 100 THEN NAME
    ELSE LEFT(NAME, 97) + '...'
  END SHORTNAME
FROM TABLE