Limiting the amount of characters returned

Discussion in 'ASP General' started by kevin@kevingibbons.co.uk, Sep 18, 2006.

  1. Guest

    Hi,

    I am looking to return the first 50 characters from a database field.
    Does anyone know if there is a SQL function that returns a defined
    amount of characters from a database field?

    Thanks in advance,
    Kevin
    www.seoptimise.com
     
    , Sep 18, 2006
    #1
    1. Advertising

  2. Guest

    Sorry I meant ASP, SQL would be fine too though.
     
    , Sep 18, 2006
    #2
    1. Advertising

  3. wrote:
    > Hi,
    >
    > I am looking to return the first 50 characters from a database field.
    > Does anyone know if there is a SQL function that returns a defined
    > amount of characters from a database field?


    Of course there is. However, we cannot get specific without knowing what
    database you are using: Access? MS SQL Server? Oracle? Something else?

    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"
     
    Bob Barrows [MVP], Sep 18, 2006
    #3
  4. Answered by several people in sqlserver.programming. Please don't
    multi-post.




    <> wrote in message
    news:...
    > Hi,
    >
    > I am looking to return the first 50 characters from a database field.
    > Does anyone know if there is a SQL function that returns a defined
    > amount of characters from a database field?
    >
    > Thanks in advance,
    > Kevin
    > www.seoptimise.com
    >
     
    Aaron Bertrand [SQL Server MVP], Sep 18, 2006
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bharath
    Replies:
    1
    Views:
    666
    David R. Conrad
    Apr 3, 2004
  2. Roffers
    Replies:
    1
    Views:
    497
  3. Paul
    Replies:
    3
    Views:
    140
    dotnettester
    Jul 7, 2005
  4. Rogue Chameleon

    Limiting characters in a text box

    Rogue Chameleon, Nov 18, 2004, in forum: Javascript
    Replies:
    10
    Views:
    159
    Rob B
    Nov 23, 2004
  5. Nospam
    Replies:
    3
    Views:
    111
    Jens Thoms Toerring
    Aug 14, 2007
Loading...

Share This Page