Yes you can. Use this as an example:

declare @STR nvarchar(1000)

set @STR = 'profit profit'

select len(replace(@str, 'profit', 'profit_'))-len(@str)

-Mike

Although not TSQL specific, Joe Celko's SQL For Smarties has always been one of my favorites.

-Mike

Michael Levy

ma_levy@hotmail.com

quote:

---

I have tested yours replies but when I run my stored procedure from an aspx page raise an exception...

---

This really sounds more like a presentation operation. What about having your front-end do this?

-Mike

Michael Levy

ma_levy@hotmail.com

Would you post the code that is calling the stored procedure?

-Mike

Michael Levy

ma_levy@hotmail.com

Can you make the CURSOR parameter optional. Then you wouldn't have to map a parameter to it when making the ADO call.

-Mike

Michael Levy

ma_levy@hotmail.com

I seem to remember seeing a string propering script at http://www.swynk.com

-Mike

Michael Levy

ma_levy@hotmail.com

What about using a table function for your application state and UNIONing it into the the query that returns the rest of the query?

-Mike

Michael Levy

ma_levy@hotmail.com