sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

Create ASSEMBLY AlphaNumeric 
FROM 'SQLAlphaNumericSort.dll'
WITH PERMISSION_SET = SAFE;
GO

CREATE FUNCTION [dbo].GetAlphaNumericOrderToken (@str nvarchar(40))
RETURNS nvarchar(50)
AS EXTERNAL NAME [AlphaNumeric].[AlphaNumericSort].[GetAlphaNumericOrderToken];
GO

/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
CREATE TABLE dbo.Jobs
	(
	JobNumber nvarchar(40) NOT NULL
	)  ON [PRIMARY]
GO

Insert into Jobs(JobNumber) Values('0');
Insert into Jobs(JobNumber) Values('435');
Insert into Jobs(JobNumber) Values('23');
Insert into Jobs(JobNumber) Values('J5678');
Insert into Jobs(JobNumber) Values('J1');
Insert into Jobs(JobNumber) Values('JJ435');
Insert into Jobs(JobNumber) Values('a332');
GO

Select JobNumber, dbo.GetAlphaNumericOrderToken(JobNumber) from Jobs Order By dbo.GetAlphaNumericOrderToken(JobNumber);
Go