Building a little script in SQL to allow me to autogenerate mobile phone numbers.
I know I can do this with Red-Gate's Data Generator but it is nice to build the SQL yourself.
Anyways the SQL to pad the mobile phone number with zeroes is:
-- This ensures my number is 11 digits long 079 + 8 other digits (padded with zeroes at the beginning
'079' + REPLICATE('0', (8 - LEN(@number))) + @number)