Home Forums SQL Server 2005 SQL Server 2005 General Discussion How to Specify Length of Output Column in SELECT Stmt? RE: How to Specify Length of Output Column in SELECT Stmt?

  • May 21, 2010 at 4:01 pm

    #1171135

    Try this:

    SELECT LEFT(RTRIM(@@servername),10)

    RTRIM to remove any trailing blanks

    LEFT (in this case 10 characters) - counting from left to right.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]