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
 Transact-SQL (2000)
 character index

Author  Topic 

hybridGik
Starting Member

26 Posts

Posted - 2006-07-06 : 15:45:50
hi

is there a way to get the index of a specific character using sql?

sample:

('100','200')

how will i get the index of the comma(,) using sql?

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-06 : 15:55:56
Take a look at CHARINDEX and PATINDEX functions in SQL Server Books Online. You should also review all of the different character functions.

Tara Kizer
aka tduggan
Go to Top of Page

hybridGik
Starting Member

26 Posts

Posted - 2006-07-06 : 16:47:18
great. thank you very much.
Go to Top of Page
   

- Advertisement -