Public feed #602656

Stuff

public sql v1 · immutable
Raw Edit
·published 2007-07-04 06:29 UTC
rendered paste body
SELECT WelderIdAscii =	CASE 	WHEN len(WelderId) = 2 THEN ( ASCII(WelderId) * 10000 ) + ( ASCII(SUBSTRING(WelderId,2,1) ) )	WHEN len(WelderId) = 3 THEN ( ASCII(WelderId) * 10000 ) + ( ASCII(SUBSTRING(WelderId,2,1) ) * 100 ) + ( ASCII(SUBSTRING(WelderId,3,1) ) )	END,WelderIdFROM #lettersORDER BY WelderIdAscii DESC