- Home
- Developer Center
- Documentation CLR Data Masking Components
- Names With Gender Dynamic
CLR Data Masking Components
CLR Reference
CLR Data Masking Components
Open Navigation Article
- Home
- Developer Center
- Documentation CLR Data Masking Components
- Names With Gender Dynamic
Name With Gender Dynamic
CLR function
SQLCLR:
SELECT [dbo].[NameWithGenderDynamic] (<@name, nvarchar(4000)>, <@gender NVARCHAR (4000)>)
Expected input
Data: Any non-empty string gender: Gender Clause (ex. Ms., Mrs, etc.). Can be empty.
Expected output
Gender is non-empty and has valid gender format or name contains gender clause: Common Name with corresponding gender (nvarchar(MAX)) Gender is empty or has invalid format and name doesn’t contain gender clause: Common unisex name
Error handling
Returns an empty string when passing empty or NULL value in name parameter.
Example
SQLCLR:
SELECT [dbo].[NameWithGenderDynamic] ('Mrs. Bob Dilan')
×
CLR Reference: Names With Gender Dynamic
CLR Reference: Names With Gender Dynamic
- 1. Name With Gender 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