yes these files are genterated by DTS package to a .txt file

it is generating the file from one table with two column's in it

in that one column is a...

iam using something like this but would like to know if there is a better way of doing it

DECLARE @ele money

SET @ele = 98.7670

select REVERSE(SUBSTRING(REVERSE(CONVERT(VARCHAR(50),convert(decimal(25,4),@ele))), PATINDEX('%[1-9]%', REVERSE(CONVERT(VARCHAR(50),convert(decimal(25,4),@ele)))),50))

let me put it this way

T1 T2 T3

90 9 5

90 0 3

90 1 8

90 2 2

91 3 4

91 4 1

91 5 6

91 6 7

91 8 2

92

92...........

output should be

OUTPUT:

OUTPUT:

T1 T2 T3

90...

NO , dont have to grouped or ordered

it woks

thanks

thanks for your response i did post the query againg as v2