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 2005 Forums
 Transact-SQL (2005)
 Get Index of String from sql query

Author  Topic 

prasadsql
Starting Member

6 Posts

Posted - 2010-01-12 : 00:43:15
hi,

How to get index of particular number or character
from sql query,what is syntax for it.

if any one know, reply me soon

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2010-01-12 : 00:46:18
select charindex('e','Sample',0)

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/
Go to Top of Page
   

- Advertisement -