Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2002
    Location
    india
    Posts
    41

    Unanswered: column length reducing

    The length of a column is 20(varchar),
    When i m trying to execute select column name it gives all 20 characters.

    My requirement is - is there any option by which i will be able to see only 10 characters ?

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    select left(10,columnname)
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    umm...think you go t it backwards...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393
    nope it's an anagram

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by Karolyn
    nope it's an anagram
    Is anagram an alias for incorrect syntax

    Code:
    USE Northwind
    GO
    
    --SELECT LEFT(10,LastName) FROM Employees
    
    SELECT LEFT(LastName,10) FROM Employees
    GO
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    My Bad !!!

    Can blame it on another long day perhaps
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •