Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 display field values in reverse order...

Author  Topic 

raaj
Posting Yak Master

129 Posts

Posted - 2008-05-14 : 10:58:07
Hi guys,
I am having a column named column1.
It has values something like this:
ABC/DEF/GHI
JKL/MNO/PQR/STU
DDE/JUR/XYZ

now, i want those values to be displayed in this way:
GHI/DEF/ABC
STU/PQR/MNO/JKL/
XYZ/JUR/DDE

i knaow there is a reverse function in sql 2000, but it reverses each and every character (which is not answer to my question).
I just want the result set to be displayed as i mentioned above.

Thanks,
raaj.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-14 : 11:51:43
Make a UDF like this:-
CREATE FUNCTION dbo.ReverseValues
@ValueList varchar(8000),
@Delimiter char(1)
RETURNS varchar(8000)
AS
BEGIN

DECLARE @String varchar(100),@Final varchar(8000)

WHILE @ValueList IS NOT NULL
BEGIN
SELECT @String=CASE WHEN CHARINDEX(@Delimiter,@ValueList)>0
THEN LEFT(@ValueList,CHARINDEX(@Delimiter,@ValueList)-1)
ELSE @ValueList
END,
@ValueList= CASE WHEN CHARINDEX(@Delimiter,@ValueList)>0
THEN SUBSTRING(@ValueList,CHARINDEX(@Delimiter,@ValueList)+1,LEN(@ValueList))
ELSE NULL
END
SET @Final=@String+ COALESCE('/'+ @Final,'')
END
RETURN @Final
END


then try like this
UPDATE YourTable
SET yourCol=dbo.ReverseValues(YourCol,'/')
Go to Top of Page

raaj
Posting Yak Master

129 Posts

Posted - 2008-05-14 : 13:00:05
Thats perfect.

Thanks visakh.
Go to Top of Page
   

- Advertisement -