Hi Lowell

I got the solution thanks for spending ur valuable time ...

Thanks

Seshu

Hi Lowell

I tried ur example wt u posted but my problem is in my database i am having data like 30.6.1 so how to sort...

hi

In my Database the datatype is nvarchar and it consist of various types of data like as i mentioned so i like to sort that data...

Hi ,

I am in critical position any one can help me from this condition . Actual my problem is in my table there is a nvarchar type data which...

hi

Actually my table consist of different data like as i mentioned above it have int,float,char so i would like to sort that data is there any...

select * from (Select REPLACE(LTRIM(REPLACE(cm_submittal_no, '0', ' ')), ' ', '0') orginal

From prj_detail_submittal order by cm_submittal_no) asc

is this query works .... please let me know...

sorry it is also wont works is there any alternate way...

37

38

39

40

40

43

44

45

47

96

98

99

1

1

1

1

1

10

10

10

10

102

103

10c

11

11

11

11

110

12

12

12

12

1233333

13

13

13

13

14

14

14

14

15

15

15

15

15a

15b

15b

15c

15c

15d

15e

16

16

16

16

17

17

17a

17b

17c

17d

17e

18

18

18

19

19

19

19.1

19.2

1A

2

2

2

2

2.5

20

20.1

20.1

20.2

20.2

up to some instance the sort is working after that again breaks...

please help me ...

Thanks

seshu