February 12, 2009 at 9:18 am
I have one line with 30 characters and space included..
i need to find one particular word 'create' from first 15 characters of this line or string
what function can i use in sql-2000?
i cant use like or not like here..
February 12, 2009 at 9:21 am
Do you have a full text index on the string?
Why can't you use "like"? That's the most obvious and easy answer.
Or is this a homework question and you're being tested on whether you can come up with something different, even if it's not better?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 12, 2009 at 9:48 am
Look up PatIndex in BOL.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply