Not logged in - Login


View History
R
e
q
u
e
s
t

a

d
e
m
o

CLR Reference: US Phone Nu Dynamic

{TOC}

"US Phone Nu Dynamic"

CLR function

SQLCLR:

SELECT [dbo].[UsaPhoneDynamic] (<@usaPhone, nvarchar(4000)>)

Expected input

Data: numeric USA Phone (can contain separators). Length without separators - 10 digits.

Expected output

Generic USA Phone of the same format as input (nvarchar(MAX))

Error handling

Returns an empty string when passing empty or NULL value. Fails on digits count less or more than 10

Example

SQLCLR:

SELECT [dbo].[UsaPhoneDynamic] ('898.456.4456')

Download a Trial