sql query

[sridhar21]

hi to all

i am sridhar

i have 1 doubt

Query to select the text after a particular character


for example

Sridhar's

i want to select the text after ' (single quote)

the result is 's'

i need query for this


thanks

[chandu031]

hi to all

i am sridhar

i have 1 doubt

Query to select the text after a particular character


for example

Sridhar's

i want to select the text after ' (single quote)

the result is 's'

i need query for this


thanks

Hi,

This is the query:
[code=sql]

SELECT SUBSTRING('SRID HAR''S',CHARIND EX('`','SRIDHAR `S',1)+1,LEN('S RIDHAR''S'))

[/code]

However this will not work if you are looking for the second or higher instances of the search character(apost ophe in your case).

Cheers!

[vijaii]

SELECT right(Descripti on,len(Descript ion) - charindex(char( 39), Description))

Here Description is the name such as "sridhar's"
char(39) = " ' "

However this will not work if you are looking for the second " ' "