Not logged in - Login


View History
R
e
q
u
e
s
t

a

d
e
m
o

CLR Reference: Address

{TOC}

"Address"

CLR function

SQLCLR:

SELECT [dbo].[AddressRandom] (<@address, nvarchar(4000)>)

Expected input

An address: Address Line 1 or/and 2. (Any address form)

Expected output

An address: Address Line 1 or/and 2. ([Street number] [Street direction] [Street name] [Street type])

Error handling

Returns an empty string when passing empty or NULL value.

Example

SQLCLR:

SELECT [dbo].[AddressRandom] ('12 Ocean St')

Download a Trial