467,077 Members | 981 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,077 developers. It's quick & easy.

SUBSTRING question

I am trying to find a way to dynamically retrieve the substring
starting point for an nText field.
My query looks something like

SELECT ID,Substring(DOCTEXT,0,200) from mytable where DOCTEXT like
'claim%'"

This query has substring starting point set to 0. Is there a way to
determine the starting point based on the first occurrence of the
search term? If first occurrence of 'claim' is at 25th character then
the query should start substring at 25th and end at 225th character. I
am trying to avoid usage of UDF. Is there a way to handle this through
plain a SQL statement? Any help would be appreciated. TIA.

Jul 23 '05 #1
  • viewed: 3636
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by sysindex@gmail.com | last post: by
6 posts views Thread by dreamerbin@gmail.com | last post: by
2 posts views Thread by Mike P | last post: by
3 posts views Thread by colinhumber@gmail.com | last post: by
2 posts views Thread by David Filion | last post: by
2 posts views Thread by mallard134@hotmail.com | last post: by
11 posts views Thread by fniles | last post: by
3 posts views Thread by =?Utf-8?B?anAybXNmdA==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.