CLR Reference: Names With Gender Dynamic

Request
a trial
Request
a demo
Request
a quote

API Reference

SSIS Reference

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

1. Name With Gender Dynamic
1.1 CLR function
1.2 Expected input
1.3 Expected output
1.4 Error handling
1.5 Example

Download Manual