Function with return values

Question

I have written a function which takes the Name as input and returns Suffix. I want to return the position of suffix in a name with a function. How can i do that. Could any one please help me doing it.

heximal · Accepted Answer · 2011-09-19 08:30:50Z

1

there is no need to create special function fot this. it already exists in t-sql. its name is PATINDEX Example:

declare @pat varchar(128)
set @pat = '_suf'
select login, Patindex('%'+@pat, login) as suffix_index from clients

edited Sep 19, 2011 at 8:30

answered Sep 15, 2011 at 7:25

heximal

10.5k5 gold badges49 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Shine Over a year ago

The problem with using Patindex is that, if the name has sililar pattren twice then it will find the position of first occered position in word. Example: Advin Dovin DO . patindex returns 6 not 13.

heximal Over a year ago

you may compose your pattern as '%'+Name - this matches your purpose

Shine Over a year ago

Could u please help me out doing this.

heximal Over a year ago

look at the example i've added to my answer.

Shine Over a year ago

I think i need to write patindex('%'+@pat+'%',Login) is it.?

|

Collectives™ on Stack Overflow

Function with return values

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related