UFN_SMARTFIELD_AGEBIN
Calculates an age bracket for the given age.
Return
| Return Type |
|---|
| nvarchar(8) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @AGE | int | IN |
Definition
Copy
CREATE FUNCTION dbo.UFN_SMARTFIELD_AGEBIN(@AGE INT)
RETURNS NVARCHAR(8)
AS
BEGIN
DECLARE @SMARTFIELDVALUE NVARCHAR(8);
SELECT @SMARTFIELDVALUE
=
CASE
WHEN @AGE IS NULL THEN
'<blank>'
WHEN @AGE = 0 THEN
'0'
WHEN @AGE <18 THEN
'1 - 17'
WHEN @AGE BETWEEN 18 AND 25 THEN
'18 - 25'
WHEN @AGE BETWEEN 26 AND 35 THEN
'26 - 35'
WHEN @AGE BETWEEN 36 AND 45 THEN
'36 - 45'
WHEN @AGE BETWEEN 46 AND 55 THEN
'46 - 55'
WHEN @AGE BETWEEN 56 AND 65 THEN
'56 - 65'
WHEN @AGE BETWEEN 66 AND 75 THEN
'66 - 75'
WHEN @AGE > 75 THEN
'76 - '
END
RETURN @SMARTFIELDVALUE;
END