1. 

   Derpost Active Member

   Messages:

   95

   Likes Received:

   0

   Best Answers:

   0

   Trophy Points:

   61

   #1

   i want to select first 100 character in text column with SQL.
   i doesnt want substr function.
   

    

   Derpost, Jun 5, 2011 IP
   
2. 

   Minimal Hank Peon

   Messages:

   136

   Likes Received:

   2

   Best Answers:

   0

   Trophy Points:

   0

   #2

   SELECT LEFT (column, 100) FROM table

   Code (markup):

    

   Minimal Hank, Jun 5, 2011 IP

• Log in with Facebook

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in