|
||||||
 |
|
|
LinkBack (1) | Thread Tools | Search this Thread |
| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
|
||||||
|
|
|
LinkBack (1) | Thread Tools | Search this Thread |
10-08-2006, 08:00 AM
|
|||
|
|||
MS SQL answer.
Re: How do I implement LastIndexOf functionality in SQLServer 2000?
SELECT case when charindex('12',s) =0 then 0 else length(s)-charindex(reverse('12'),reverse(s)) end AS lastIndexOf, s FROM t;The above was not tested. The above finds the last index of '12' in column 's' of table 't'. Hope this helps.     
|
|
05-11-2007, 08:13 PM
|
|||
|
|||
|
ANY answer.
Re: How do I implement LastIndexOf functionality in SQLServer 2000?
This might be a little "simpler"
(CHARINDEX('.',REVERSE(ContactEmail)) > 4) This checks for the last index of a period in an email address thats position is not more than 3 places in meme.email@domain.ccom would "fail", but meme.email@domain.com and meme.email@domain.ca would "pass"
|
|
05-12-2007, 08:18 PM
|
|||
|
|||
|
ANY answer.
Re: How do I implement LastIndexOf functionality in SQLServer 2000?
Adam,
The solution you posted works only when the string to search consists of exactly one character. When a longer string is needed you need to reverse both, as in my answer #1. Don't you agree? Dimitar
|
|
| Thread Tools | Search this Thread |
|
|
LinkBacks (?)
LinkBack to this Thread: http://www.sqlrecipes.com/sql_questions_answers/how_do_i_implement_lastindexof_functionality_sqlserver_2000_a-57/
|
|||
| Posted By | For | Type | Date |
| digiduck's bookmarks on del.icio.us | This thread | Refback | 06-14-2008 05:02 AM |
