Thakns.

helped a lot.

Jeff Moden (10/21/2007)

---

No, no! The Tally table in this code was just to have a table to demonstrate from... I copied it from the previous post that MrPoleCat posted......

Jeff Moden (10/20/2007)

---

Not sure what you're trying to do, but here's a different angle... think of it as a "set-based IF" 😀

SELECT TOP 1

...

Jeff Moden (10/20/2007)

---

vadimt (10/18/2007)

---

the first solution didnt work. because of the Tally i didnt implement.

i dont need it as a function because i need it only in one place in...

thanks.

i knew it was supposed to be...

Jeff Moden (10/18/2007)

---

the first solution didnt work. because of the Tally i didnt implement...

ps.

meanwhile the client "revised" some specs, so i do need these numbers now. but i still need...

Max Yasnytskyy (10/17/2007)

---

I have found an interesintg function in msdb, seems like it is working much better

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[udfTRANSELATE] (@mixedString AS varchar(max))

RETURNS varchar(max)

as

BEGIN

DECLARE @resultString...

Greg Snidow (10/17/2007)

---

This ought to work. Jeff Moden helped me with a couple of these, and I think this is one of them, but I can not remember exactly,...