SQL Alpha Numeric Sort Using CLR Integration

shteff

Rate me:

4.89/5 (8 votes)

13 Apr 2009CPOL5 min read

30.7K

182

How to do a sort on alphanumeric strings in SQL Server.

code.zip
- SQLAlphaNumericSort
  - AlphaNumericSort.cs
  - bin
    - Debug
      - SQLAlphaNumericSort.dll
  - CreateSQLFunction.sql
  - SQLAlphaNumericSort.csproj
  - SQLAlphaNumericSort.dll
  - SQLAlphaNumericSort.sln


Microsoft Visual Studio Solution File, Format Version 9.00
# Visual Studio 2005
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "SQLAlphaNumericSort", "SQLAlphaNumericSort.csproj", "{3D2E381E-A051-46CE-AF8A-D5B0E16F11F7}"
EndProject
Global
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
		Debug|Any CPU = Debug|Any CPU
		Release|Any CPU = Release|Any CPU
	EndGlobalSection
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
		{3D2E381E-A051-46CE-AF8A-D5B0E16F11F7}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{3D2E381E-A051-46CE-AF8A-D5B0E16F11F7}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{3D2E381E-A051-46CE-AF8A-D5B0E16F11F7}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{3D2E381E-A051-46CE-AF8A-D5B0E16F11F7}.Release|Any CPU.Build.0 = Release|Any CPU
	EndGlobalSection
	GlobalSection(SolutionProperties) = preSolution
		HideSolutionNode = FALSE
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

shteff

Software Developer (Senior)

Australia

I am currently a Software Engineer working for an international company on a defence project. I graduated from university in 2001 with a Bacehlor of Engineering (Aerospace Avionics) First Class Honours. Currently in my spare time I am experimenting with the joys of shareware. I also enjoy most sports including, basketball, netball and rockclimbing.
www.s3ware.com
www.s3search.com.au
Civic Shower Screens

SQL Alpha Numeric Sort Using CLR Integration

License

Comments and Discussions