Home Forums SQL Server 2014 Development - SQL Server 2014 Scalar Function - Format Numbers RE: Scalar Function - Format Numbers
hicksl
SSC Rookie
Points: 48
More actions
June 24, 2016 at 8:15 am
#1886755
Because you are passing the telephone number in as an int, so it drops the leading zero, and you should pass a string in as a string
select
[dbo].[fnFormatMobileNumber]('0842507889')