Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by amylashley
-
Substring length unknown
Ok thanks. I didn't need the LEN function. But the PatINDEX helped: KeywordBuys.URL,SUBSTRING(KeywordBuys.URL,charIndex('landerName',KeywordBuys.URL)+11,PATINDEX ( '%&misc%' , KeywordBuys.URL )-(charIndex('lander',URL )+11))- amylashley
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Substring length unknown
Is there a way using SQL Queries to extract a substring when the length of it is not known? It seems like such a simple thing but all I see is a SUBSTRING function that requires knowledge of the length of the substring in advance. Thanks- amylashley
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
