0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers and researchers interested in open data

select top 10 right(userid,5) from badges


DECLARE
   @pad_characters VARCHAR(10)

SET @pad_characters = '0000000000'

SELECT RIGHT(@pad_characters + '123456', 10)

fork query

edited feb 18 13

created feb 18 13 anonymous