Oh and of course I got it wrong... because I just went with
SELECT ASCII('Z')-ASCII('0')
Sadly I'm just too dang American... A thru Z, 0 thru 9... sure... but ASCII isn't Latin1_General_CI_AS
--Mark Tassin MCITP - SQL Server DBA Proud member of the Anti-RBAR alliance. For help with Performance click this link[/url] For tips on how to post your problems[/url]