CLR Reference: Address
-
Request
a trial -
Request
a demo -
Request
a quote
CLR Data Masking Components
Open Navigation Article
CLR Reference: Address
-
Request
a trial -
Request
a demo -
Request
a quote
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')
×
![Enlarged Picture]()
CLR Reference: Address
Download Manual
