CLR Reference: Address

{TOC}

"Address"

CLR function

<.CLRSELECT function:[dbo].[AddressRandom] xxxxx(xxx,xxx,xxx)>(<@address, nvarchar(4000)>)

Expected input

<.expectedAn input:address: dataAddress type,Line rule,1 sample>or/and 2. (Any address form)

Expected output

<.expectedAn output:address: dataAddress type,Line rule,1 sample>or/and 2. ([Street number] [Street direction] [Street name] [Street type])

Error handling

<.errorReturns handling>an empty string when passing empty or NULL value.

Example

<.example>SQLCLR: SELECT [dbo].[AddressDynamic] ('12 Ocean St') SELECT [dbo].[AddressRandom] ('12 Ocean St')