0

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
8
Views
9 Years
Discussion Span
Last Post by Venom Rush
1

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 ..

Votes + Comments
A "VERY" helpful post. Thanks for the help ;)
0

y

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

0

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 ;)

0

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.