>try
>

>SELECT PADR(CHRTRAN(DealNumber,[ 0123456789],[]),10) AS TrimmedDeal
>

Boris,

I was excited since this was a great solution, however I found later in the data that it ruined the results for a deal number like BPB2-SP2, where I would want the first "2" to remain intact.

Any ideas?

Laterness,
Jon