I wondered if this was possible.
I have a query that is selecting a couple of fields, one of which is a varchar field used to collect the answer to a question. I am currently selecting the first 100 characters in that field to get a 'snippet' of the question, but I was asked instead to just select the first sentence. Is there a way to select up until the first period is encountered?
Thanks!
Cynthia
This is my current query......
SELECT p.id, p.pp_name, substring(p.question1, 1, 100) AS question1, c.Zip
FROM personalpagesindex p
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
