How to sort nvarchar field in SQL?

Frank

Member

26 Points

13 Posts

Hi,

I have a field ID. It has data something like dec2,dec345,dec23,....

How can sort it.

Views: 8479
Total Answered: 1
Total Marked As Answer: 0
Posted On: 28-Dec-2015 09:39

Share:

Answers

Smith

None

2568 Points

74 Posts

Hi Frank,

If three char is fix 'dec' then just make sure numeric value with fix digit also. That is add '0000' before small numbers such as:

dec0002,dec0345,dec023,....

Now will apply sort in above field.

Posted On: 29-Dec-2015 09:03

Discussion

MVC Design pattern