- Home
- Developer Center
- Documentation CLR Data Masking Components
- Address Dynamic
CLR Data Masking Components
CLR Reference
CLR Data Masking Components
Open Navigation Article
- Home
- Developer Center
- Documentation CLR Data Masking Components
- Address Dynamic
Address Dynamic
CLR function
SQLCLR: SELECT [dbo].[AddressDynamic] (<@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].[AddressDynamic] ('12 Ocean St')
×
CLR Reference: Address Dynamic
CLR Reference: Address Dynamic
- 1. Address Dynamic
- 1.1 CLR function
- 1.2 Expected input
- 1.3 Expected output
- 1.4 Error handling
- 1.5 Example
CLR Data Masking Components
CLR Reference