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.
Jump to Posttry 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 ..
Jump to Post^
What are you trying to say??
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 ..
y
^
What are you trying to say??
y
:S Dude! is everything ok ? This is the 2nd time you are saying something which doesn't make any sense.
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 ;)
np boss!
Thanks ^,^
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.