Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Parsing String of (.) seperated values

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-09 : 08:25:04
Matt writes "Is there a way to parse a period (.) seperated string with a select query to get only the last word in the string. The string looks something like is "com.techtrader.products.tape". The tricky part is that the next row might be "com.techtrader.products.sealant". The last word is always a different length.

I have tried many different variation of the article about CSV parsing, but to no success."
   

- Advertisement -