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

Quote:

Originally Posted by 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

Hi,

This is the query:

Expand|Select|Wrap|Line Numbers

  
SELECT SUBSTRING('SRIDHAR''S',CHARINDEX('`','SRIDHAR`S',1)+1,LEN('SRIDHAR''S'))

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

Cheers!

vijaii

SELECT right(Description,len(Description) - 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 " ' "

sql query

re: sql query

re: sql query

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about