Member Avatar for Venom Rush

Hi there

What I'd like to do is store a paragraph in a column and pull roughly the first 200 characters of the paragraph and display them on a page as a snippet. Is this possible? If so could someone give me a link or code snippet on how to do this. I'd really appreciate it.

  • 4 Contributors
  • 7 Replies
  • 138 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Venom Rush
Member Avatar for Sulley's Boo

try these

SUBSTRING(srting, position, length)

SELECT SUBSTR(Column_name,1,200)
SELECT SUBSTRING(Column_name, 1, 200)

or

SELECT LEFT(Column_name, 200)

:?: Hope this works ..

commented: A "VERY" helpful post. Thanks for the help ;) +1
Member Avatar for Sulley's Boo

^

What are you trying to say??

Member Avatar for nav33n

y

:S Dude! is everything ok ? This is the 2nd time you are saying something which doesn't make any sense.

Member Avatar for Venom Rush

Hmmm, I was also a bit perplexed by Xsimulator.net's post.

Hi Sulley, thanks for your post. Going to give it a try a little later. ;)

P.S. Love the avatar sulley ;)

Member Avatar for Sulley's Boo

np boss!

Thanks ^,^

Member Avatar for Venom Rush

SUBSTRING(srting, position, length)

SELECT SUBSTRING(Column_name, 1, 200)

This one worked perfectly for me. Haven't tried the rest though. Thanks so much for the help.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.