devxlogo

Sorting Part of a Field

Sorting Part of a Field

Use the following code:

 select *,right(field1,4) as Col1 from [Tablename]order by col1

You can do it by using substring:

 SELECT *, substring(field1, 3, 5) as col1from [tablename]order by col1

devx-admin

Share the Post:
Show More