Drat... both of ours come up with a little problem when we have data like this...
--===== This just creates demonstrable test data and is NOT part of the solution
SET NOCOUNT ON
DECLARE @TestData TABLE(String VARCHAR(10))
INSERT INTO @TestData (String)
SELECT 'A012' UNION ALL
SELECT 'A12' UNION ALL
SELECT '12' UNION ALL
SELECT '1' UNION ALL
SELECT 'AB12' UNION ALL
SELECT 'AB2' UNION ALL
SELECT 'A' UNION ALL
SELECT ''
--Jeff Moden
Change is inevitable... Change for the better is not.